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 |
CLages
Posting Yak Master
116 Posts |
Posted - 2005-10-26 : 08:02:31
|
hi Where to find out Diagrams Tables?better yest where can i find information where in System Database arelocated information about , Tables, Colunmns, Triggers, Diagrams, etcevery time i need i have to search em Enterprise Manager.I have already looking for in BOL and find Nothing.TksClages |
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-10-26 : 08:07:03
|
Tables - sysobjects, INFORMATION_SCHEMA.TABLESColumns - syscolumns, INFORMATION_SCHEMA.COLUMNSTriggers - sysobjects, syscommentsDiagrams - dtproperties table, but the contents are binary encodedWhenever possible, you should use the INFORMATION_SCHEMA views. These are standardized, and will still function in later releases. SQL Server 2005 and higher will limit and/or remove access to system tables. |
|
|
|
|
|