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

How would you add a section to a table?

970

Do you know what are acid properties of transaction?

909

Can we insert data if clustered index is disabled?

893

How to list all dsn entries on your local machine using odbc_data_source()?

979

What are the methods used to protect against sql injection attack?

1001

What is candidate key with example?

925

How to disable triggers using "disable trigger"?

1002

How do I find sql server instance name?

917

What are the diifferences between the ms sql server vs mysql?

1123

How does Report Builder support Analysis Services cubes?

147

How to invoke a trigger on demand?

1029

What happens if the update subquery returns multiple rows in ms sql server?

1058

What is TDS(Tabular Data Stream) Gateway?

121

What is an identity?

939

Explain the cursor lock types?

984