How to get object and structure info for a table

[cshncn]

Hi,

I wonder if I can use a query to list object information for a table, such as name and datatype of columns, constraints, etc. I know this is a simple question but I just couldn't get it by myself. I have searched Books Online but not successful. Thanks!

cshncn

 

[JohnDTampaBay]

Depending on exactly what information you want, there are a variety of ways to get there. You can use sp_help tablename to get information on a table, but the results can't easily be captured in a table for manipulation. SQL2K includes Information_Schema views that provide information on database objects. Also check out functions, meta data in BOL for a list of functions that provide specific information on database objects. Good luck!

--Angel
-----------------------------------
Every time I lose my mind, I wonder
if it's really worth finding.

 

[gcole]

In Query Analyzer (SQL2000) you can right click the table and select a create statment. That will show you the fields, types ect.