name of the command to get table structure

how do i get the table structure within the sql server
2000 (the corresponding command within oracle is describe)sp_help tablename
may help
--
HTH
Ryan Waight, MCDBA, MCSE
"uwe" <uwe.woedl@.linde.de> wrote in message
news:2a70401c39259$8d5ca6f0$a601280a@.phx.gbl...
> how do i get the table structure within the sql server
> 2000 (the corresponding command within oracle is describe)|||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.
>--Original Message--
>sp_help tablename
>may help
>--
>HTH
>Ryan Waight, MCDBA, MCSE
>"uwe" <uwe.woedl@.linde.de> wrote in message
>news:2a70401c39259$8d5ca6f0$a601280a@.phx.gbl...
>> how do i get the table structure within the sql server
>> 2000 (the corresponding command within oracle is
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.
"uw" <uwe.woedl@.linde.de> wrote in message
news:00aa01c39262$bf1328a0$a101280a@.phx.gbl...
> 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.
>
> >--Original Message--
> >sp_help tablename
> >
> >may help
> >
> >--
> >HTH
> >Ryan Waight, MCDBA, MCSE
> >
> >"uwe" <uwe.woedl@.linde.de> wrote in message
> >news:2a70401c39259$8d5ca6f0$a601280a@.phx.gbl...
> >> how do i get the table structure within the sql server
> >> 2000 (the corresponding command within oracle is
> describe)
> >
> >
> >.
> >