sp_help '<TABLE NAME>'

how can i view structure of table in sql server? tell me
that query.

Question Posted / krishnaraj

Answer Posted / krishnaraj

Is This Answer Correct ?

4 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is the report model project?

137

What is the beast way to write CTE in SQL Server ?

996

What stored by the model?

1004

Tell me what are the advantages of using stored procedures?

962

Can sql servers link to other servers?

1039

What is data source document?

995

Do you know what are the reporting services components?

936

What is the maximum size of a row in sql server?

928

What is database isolation in sql server? : sql server database administration

1048

What do you understand by the data quality services in sql server?

917

What is transaction server implicit?

954

What is sql language?

1053

Define clusters?

1011

in the physical file layout, where should the transaction log be stored in relation to the data file?

957

I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?

1095