name of the command to get table structure

Microsoft SQL Server

how do i get the table structure within the sql server
2000 (the corresponding command within oracle is describe)
sp_help tablename

may help
Hello Ryan,
sorry but this is not what I want. I do get only the
number of tables within the database. I want the structure
of a table including the attributes, their formats, the
primary key and foreign keys.


describe)
If you specify a table name as the first argument to sp_help, that is
exactly what you get. Have a look at the syntax and comments in BOL.