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 |
macsterling
Yak Posting Veteran
56 Posts |
Posted - 2011-02-03 : 09:49:23
|
I need to create a document(s?) for a conversion. How can I best get a "listing" of the columns in each table and the basic charastics (type and size) |
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2011-02-03 : 10:01:03
|
select * from information_schema.columnsorder by table_nameMadhivananFailing to plan is Planning to fail |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2011-02-03 : 10:46:10
|
may be more than you need but you can also check out the link in my sig. elsasoft.org |
|
|
|
|
|