Display Tables/Design Query?

Is there a SQL command that will display the tables in a SQL 2000 database o
r
describe the layout of a table in the DB?BW,
Try:
http://www.aspfaq.com/show.asp?id=2178
and
http://www.aspfaq.com/show.asp?id=2177
and/or
SP_HELP <TABLE>
SP_COLUMNS <TABLE>
and/or
Enterprise Manager - Database Diagrams (graphical visualization)
and/or
Visio
and/or
third-party tool i.e., ERwin
etc...
HTH
Jerry
"-BW" <-BW@.discussions.microsoft.com> wrote in message
news:D126A965-39B1-48B7-8FF5-49DCE9F9182F@.microsoft.com...
> Is there a SQL command that will display the tables in a SQL 2000 database
> or
> describe the layout of a table in the DB?|||Create a diagram and click add related tables when choosing your tables
You will see all the tables with their relationships
http://sqlservercode.blogspot.com/
"-BW" wrote:

> Is there a SQL command that will display the tables in a SQL 2000 database
or
> describe the layout of a table in the DB?