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

Answer Posted / murli manohar

sp_tables @table_type = "'TABLEName'"

Is This Answer Correct ?    5 Yes 9 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is scalar user-defined function?

541


What is cte (common table expression)?

593


What is a linked server in sql server?

569


What is a transactions?

598


What types of replication are supported in sql server?

556






What is the xml datatype?

619


How to return the top 5 rows from a select query in ms sql server?

584


What are the types of normalization?

547


What is user-defined function?

563


How to count rows with the count(*) function in ms sql server?

534


How to rebuild all indexes on a single table?

581


Detail about the hardware which is supported by SQL server?

580


Explain magic tables in sql server?

545


What is the primary use of the model database?

615


What is the default sql server instance name?

556