sp_help <tablename>

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

Question Posted / vidit tyagi

Answer Posted / vidit tyagi

sp_help <tablename>

Is This Answer Correct ?

10 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Define cursor locking

1058

what is memory-optimized nonclustered indexes

1060

Does any body please help me what question's have asked for SSRS in the interview?

2201

what is a self join? Explain it with an example? : Sql server database administration

1002

Explain what are the database objects? : SQL Server Architecture

1141

How to create database with physical files specified in ms sql server?

1033

Explain the use of containers in ssis and also their types?

1015

Explain differences between web edition and business edition?

119

How to call stored procedure using http soap?

1125

What is sql server schema compare? How we can compare two database schemas?

1076

What are the types of database schema? : sql server analysis services, ssas

1184

Do you know what is difference between stored procedure and user defined function?

1146

What are the disadvantages of using the stored procedures?

1183

Explain how many types of relationship?

1081

How do I view a procedure in sql server?

1036