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 |
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
 Posted - 2006-05-25 : 13:08:45
|
| GurusWhen ever we create a new table ,itz entry is stored in the master DB somewhere?right?Can you please tell mewhere the entry is stored?REgardsNitin |
|
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
Posted - 2006-05-25 : 13:17:03
|
| Ohhhhhhhhhhhhhhhi am such a big dumbo...itz in the same db i.e sysobjectsRegardsNitin |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-05-26 : 04:15:04
|
| Note that if you create temporary tables, they are created in tempdb databaseMadhivananFailing to plan is Planning to fail |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-05-26 : 04:56:20
|
And unless you specify the db name in the create table, it will create in the current db.create table db2.dbo.table( . . .)
KH |
|
|
|
|
|
|
Entry for new table?