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 |
|
azamsharp
Posting Yak Master
201 Posts |
 Posted - 2005-09-19 : 22:50:09
|
| is there any T-SQL command that I can get the Table description. Like fields and triggers associated with the database. OR even better how about i can get information about tables. Mohammad Azam www.azamsharp.net |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-09-19 : 23:29:45
|
| Your could Script the table from Enterprise Manager.Otherwise the INFORMATION_SCHEMA tables like INFORMATION_SCHEMA.TABLES and INFORMATION_SCHEMA.COLUMNS have info about the structure and type of the objectsKristen |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-09-20 : 00:50:10
|
| and also run sp_help 'TableName' to get these informationsMadhivananFailing to plan is Planning to fail |
|
|
|
azamsharp
Posting Yak Master
201 Posts |
Posted - 2005-09-20 : 11:49:34
|
| Thank you very much both of you :)Mohammad Azam www.azamsharp.net |
|
|
|
|
|
|
How to get Table Defination