A list of all the fields. 1

[brianpercival]

Is there anyway in ms sql where I canprint the table structure? I have tables with like 160 fields, don't have the queries that created them and am having a hard time to constantly shift windows to look at the required fields while coding. How can I print a hardcopy of the table structure?

regards,
Brian

 

[gmmastros]

Run the following query in Query Analyzer. You can copy/paste the results in to Excel, format the output to your needs, and then print.

Select * from Information_Schema.Columns Order By TABLE_NAME, ORDINAL_POSITION

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[brianpercival]

gmmastros, thanks for your response.

My table name is "table1" in database "database1". I tried running

select * from Information_Schema.Columns Order By table1, ORDINAL_POSITION

It comes up saying invalid column name "table1". What am I doing wrong?

regards,
Brian

 

[gmmastros]

try running the code EXACTLY as shown. TABLE_NAME is a field returned by the query. It will show all tables and their columns (fields). If you want just a single table, then you can run this...

Select * from Information_Schema.Columns 
Where Table_Name = 'Table1'
Order By TABLE_NAME, ORDINAL_POSITION

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[r937]

TABLE_NAME is the name of a column in the Information_Schema.Columns table

if you want to show the layout of just one table, use a WHERE clause --

select * 
  from Information_Schema.Columns 
 where TABLE_NAME = 'table1'
order 
    by ORDINAL_POSITION

r937.com | rudy.ca

 

[r937]

aarg, you beat me by a minute

r937.com | rudy.ca

 

[gmmastros]

r937, nice query though.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom