Monday, March 12, 2012

Requesting querry to view structure

Hi,
Can anybody please help me in writing the syntax to view the structure
of the table in sqlserver 2005.
For example in oracle if we want to see the table structure we will use
the command
desc table name.In similar way is there any command to view the table
structure we have created in sqlserver2005.
ThanksEXEC sp_help 'tablename';
"ganu" <girijak@.hotmail.com> wrote in message
news:1140547519.059657.128250@.g47g2000cwa.googlegroups.com...
> Hi,
> Can anybody please help me in writing the syntax to view the structure
> of the table in sqlserver 2005.
> For example in oracle if we want to see the table structure we will use
> the command
> desc table name.In similar way is there any command to view the table
> structure we have created in sqlserver2005.
>
> Thanks
>

No comments:

Post a Comment