is there an sp_ that can show me a how a table is defined?

[aolb]

is there an sp_ that can show me a how a table is defined?

been looking for a while and haven't seen it yet.

thanks

 

[db999]

sp_help <tablename>
should give you information about table

 

[tlbroadbent]

Look for system stored procedures in SQL BOL. You probably want to use sp_columns. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains &quot;Suggestions for Getting Quick and Appropriate Answers&quot; to your questions.

 

[aolb]

Thanks, just what I was looking for