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

Answer Posted / ram

sp_help <table name>

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the maximum size of a row in sql server?

536


Which operator do you use to return all of the rows from one query except rows are returned in a second query?

579


What is BCP? When does it used in sql server 2012?

586


What are “lost updates”?

619


What are the drawbacks of reporting in ssrs?

108






Explain about system database?

589


Explain about service Broker functions?

623


What are difference between Cluster index and Non-Cluster index?

618


Define inner join in sql server joins?

540


How to find out what is the default collation in a database?

638


What are the advantages to use stored procedures?

582


Explain what is row_number function?

577


What is database black box testing?

621


Mention the 3 ways to get a count of the number of records in a table.

560


Please illustrate physical database architecture? : SQL Server Architecture

540