SP_help < table

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

Question Posted / anil panwar

Answer Posted / anil panwar

SP_help < table_name>

Is This Answer Correct ?

54 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Explain partitioned view?

1131

What are .mdf files?

1016

What does this statement do @@rowcount?

1016

How many types of stored procedures are there in sql server?

1057

Can sql servers link to other servers like oracle?

894

Why are views required in the sql server or in any other database?

1001

Difference between report and query parameter. Why do we need different type of parameter?

1011

Do you know what is difference between index seek vs. Index scan?

1002

To which devices can a backup be created and where should these devices be located? : sql server management studio

1102

What is checkpoint process in the sql server?

1074

Does view occupy space?

991

What do you mean by sql server agent?

1040

What are the 3 types of schema?

1176

What are different types of raid configurations? : SQL Server Architecture

1133

Explain sql delete command?

1091