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

Answer Posted / krishnaraj

sp_help '<TABLE NAME>'

Is This Answer Correct ?    4 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How does a profiler work?

661


Detail about the hardware which is supported by SQL server?

755


What security features are available for stored procedure?

763


What is the difference between system objects and user objects?

883


Can truncate be rolled back?

701






What is data source view or dsv? : sql server analysis services, ssas

754


What is the full form of ddl?

664


What is the difference between cube operator and rollup operator? : SQL Server Architecture

817


Write the SQL query to drop, truncate and delete table.

724


How to backup encryption key ?

144


How to delete an existing row with delete statements in ms sql server?

767


What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas

916


What is dbcc updateusage?

842


What is a mixed extent?

753


what is an extended stored procedure? : Sql server database administration

706