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

Explain comment on transactions?

1041

Explain what is meant by replication of database?

1106

What are the new features in SQL Server 2005 when compared to SQL Server 2000?

1212

How to rebuild all indexes on a single table?

1107

What is ms sql server reporting services?

1123

Explain the rules for designing files and file groups in sql server?

1022

What are various ways to enhance the ssrs report?

1032

Why I am getting this error when dropping a database in ms sql server?

1119

How to generate create view script on an existing view?

1038

What is catalog views?

1121

How can you know if the row fetched from cursor is still valid in underlying table?

1044

What is identity?

1080

What is merge?

1070

Do you know exporting and importing utility?

1105

What is Dependency Injection and provide example?

1178