Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
putane.sanjay
Yak Posting Veteran
77 Posts |
 Posted - 2006-11-13 : 00:23:52
|
| if i create tabel in model database what will happen |
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2006-11-13 : 01:12:56
|
| when you create any table in the model table, it will autmatically exists in any of the database which you create after that. Also if you restart your database then you will find that tables, in the Temp db too.Chiraghttp://chirikworld.blogspot.com/ |
 |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-11-13 : 01:13:12
|
You will get following message in the Results pane of QA:The command(s) completed successfully. What do you expect? Model database is just like any other database and you can create table in it. Only significant thing is that next time you create any user-defined database, the newly created table in Model database will also be created in your database, because Model database is used as a template to create any user-defined database.Harsh AthalyeIndia."Nothing is Impossible" |
|
|
|
putane.sanjay
Yak Posting Veteran
77 Posts |
Posted - 2006-11-16 : 00:41:16
|
| Thank you for your nice reply. |
|
|
|
|
|
|
model database