Can Table Properties Be Printed? 1

[Rob7]

Hi All,
In Enterprise Manager, you can highlight a table in a database, right click and choose Properties and get the field names, data type and size. Is there a way to print this out? It would sure make writing data conversion code alot easier.

Rob

Cytec Corporation
rbrown@cyteccorp.com

 

[sunila7]

Hi,

U can go to query analyzer and type

sp_help tblname

which will list the details of the Table... u can print this out...

hope it helps

Sunil

 

[Rob7]

Thanks Sunil! That will work.

Cytec Corporation
rbrown@cyteccorp.com