How to display skeleton of table in sql server 2000

[davidson1]

Hai friends,

To display skeleton of table we have in oracle

desc student;

name char(200)
age number(10)

In SQLSERVER do we have any command to display skeleton of table like above.
Please help me...Thank U in advance....

[ck9663]

Hai friends,

To display skeleton of table we have in oracle

desc student;

name char(200)
age number(10)

In SQLSERVER do we have any command to display skeleton of table like above.
Please help me...Thank U in advance....

if you mean table structure/definition, try doing

sp_help mytable

-- ck

[davidson1]

Thank U ck9663

I have tried a lot , to get this.........
I got through U.............. .

Th U......