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 |
|
madhivanan
Premature Yak Congratulator
22864 Posts |
 Posted - 2005-05-13 : 02:18:57
|
| I can use queries to retreive many informations from INFORMATION_SCHEMASELECT * FROM INFORMATION_SCHEMA.Columns WHERE TABLE_NAME = 'tablename'But I want to know how to find where that table exists as it is not part of sysobjectsMadhivananFailing to plan is Planning to fail |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-05-13 : 05:17:42
|
| information_schema is a view for the objects that are within the current dbnot sure if i understand what you want to retrieve?--------------------keeping it simple... |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-05-13 : 05:22:41
|
| jen, yes I got it. INFORMATION_SCHEMA is the owner and columns is the view which is in Master databaseMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
INFORMATION_SCHEMA information