sp_tables @table_type = "'TABLEName'"

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

Question Posted / murli manohar

Answer Posted / murli manohar

Is This Answer Correct ?

5 Yes

9 No

Please Help Members By Posting Answers For Below Questions

How do I find the default sql server instance?

912

What it means to be triggered?

930

What is a periodical index?

880

What are sql dirty pages?

984

What is the difference between drop table and truncate table?

889

Explain for xml explicit mode?

925

What is statement level trigger?

949

What is sql profiler. What are the default templates with it? : sql server database administration

971

What are the differences between substr and charindex in sql server.

1039

Can we use where and having clause together?

989

Does partitioning improve performance sql server?

916

How can you check the level of fragmentation on a table?

999

What is de-normalization in sql database administration? Give examples?

941

What happens if we shrink log file in sql server?

930

Which sql server is best?

963