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

Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?

977

Define normalisation?

1077

What is raiseerror? What is raiseerror?

1083

You want to implement the one-to-one relationship while designing tables. How would you do it?

927

Tell me what are the essential components of sql server service broker?

902

What is the purpose of indexing?

1013

How to assign null values to variables or columns?

934

How to install sql server 2005 express edition?

1068

How to enter binary string literals in ms sql server?

1108

tell me the disaster recovery plan

2473

What are two difference between sql azure and azure tables?

159

How many types of cursor type are there?

1030

What is the difference between system objects and user objects?

1124

Does order by actually change the order of the data in the tables or does it just change the output?

1094

what purpose does the model database serve? : Sql server database administration

936