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

Is it safe to delete log files?

868

What is onf in normalization form?

999

What is the impact on other user sessions when creating indexes?

873

How to concatenate two binary strings together?

1047

How many columns can we include on clustered index ?

923

What does normalization do to data?

989

What is equi join with example?

1011

Would you store your query in a ssrs report or a database server? State the reason why?

148

How can you append an identity column to a temporary table?

874

Explain ms sql server reporting services vs crystal reports?

855

How to use union to merge outputs from two queries together in ms sql server?

1006

Is it possible to replicate data from sql server to oracle? : sql server replication

1034

How to maintain a fill factor in existing indexes?

943

What is the difference between ‘having’ clause and a ‘where’ clause?

991

Why union all is faster than union?

864