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 size of a sql server database?

885

What security features are available for stored procedure?

996

How many types of triggers in sql server?

980

How to locate and take substrings with charindex() and substring() functions?

955

Explain the relational database management system (rdbms)?

1036

How to select some specific columns from a table in a query in ms sql server?

956

How do we know if any query is retrieving a large amount of data or very little data?

931

Tell me about pre-defined functions of sql?

1076

Explain what are the database objects? : SQL Server Architecture

1018

What are “lock” hints?

1010

What is an expression in ms sql server?

1025

What are the different types of collation sensitivity in sql server?

1051

What are data files?

992

What is awe?

959

How to test a dml trigger in ms sql server?

999