how can i view structure of table in sql server? tell me
that query.
- 10 Answers
- 16716 Views
- I also Faced
- E-Mail Answers
Answer Posted / vidit tyagi
sp_help <tablename>
| Is This Answer Correct ? | 10 Yes | 2 No |
Post New Answer View All Answers
Your table has a large character field there are queries that use this field in their search clause what should you do?
What is the command dbcc checkdb used for?
Why we should not use triggers?
How column data types are determined in a view?
What is 1nf 2nf and 3nf?
What is the purpose of optimization?
How do I debug a stored procedure in sql server?
How to use column default values in insert statements in ms sql server?
What is normalization according to you and explain its different levels?
What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration
What are the components of sql server service broker?
How to receive returning result from a query?
In which format does an image save in SQL Server database ?
What do you understand by physical_only option in dbcc checkdb?
How to create a large table with random data for index testing in ms sql server?
