Hi all,

I'm looking for some sql code to query a database, and what I want
returned is a description of a specific table or all tables in the
database. I'd like to run a query that returns:

table name
fields
field data types

etc...

Like a summary of the table(s).

How can I do this? Thanks.

sp_help <Tablename>

HTH, Jens Suessmeyer.