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.

 All Forums
 SQL Server 2005 Forums
 Other SQL Server Topics (2005)
 Creating table documentation

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.columns
order by table_name


Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

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
Go to Top of Page
   

- Advertisement -