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 many types of stored procedures are there in sql server?

550


How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication

545


What are the different methods available under sqlcommand class to access the data?

682


What is compound operators?

544


What is the difference between deallocate cursor and close cursor?

713






How to drop an existing table?

545


Mention what are the different types of ssrs reports?

98


Do you know exporting and importing utility?

529


how to invoke a trigger on demand? : Sql server database administration

563


What are filegroups in sql server?

577


can an order by clause be used in a creation of a view?

690


Can We Use Data-grids For Our Report In Ssrs?

147


Why people hate cursor?

725


Explain primary key?

537


What type of locking occurs during the snapshot generation? : sql server replication

862