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 |
|
sqldba2k6
Posting Yak Master
176 Posts |
 Posted - 2007-03-03 : 11:05:39
|
| I need a help in writing the scripts which will gives the output Tablename,columnname,columnlength,columntype,columntypenull/not null,tabledescription,columndescriptionTHanks for your help in advance... |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-03-03 : 11:18:00
|
see INFORMATION_SCHEMA views. in particular, see INFORMATION_SCHEMA.TABLES and INFORMATION_SCHEMA.COLUMNS.You might also have a look at the site in my sig - there's an app there that will generate all this for you in great detail.
www.elsasoft.org |
 |
|
|
Jeff Moden
Aged Yak Warrior
652 Posts |
Posted - 2007-03-04 : 13:36:25
|
| Look under the hood at Master.dbo.sp_Help...--Jeff Moden |
|
|
|
|
|
|
scripts in sqlserver 2000