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

Tell me time data type, datetime2, datetimeoffset data type in sql server 2008?

562


what is a self join? Explain it with an example? : Sql server database administration

495


Explain time data type in sal server 2008?

547


Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .

1483


What is the purpose of forms?

487






How to execute a sql statement using odbc_exec()?

566


what is a check constraint?

632


What are the new features are introduced in sql server 2012 reporting services?

105


What are sql servers used for?

503


What is the difference between DATETIME2 and DATETIME?

619


What is the maximum length of an alert name?

594


Which are the important points to note when multilanguage data is stored in a table?

510


What do you mean by an execution plan? Why is it used? How would you view it?

525


Is sql server implemented as a service or an application? : Sql server database administration

509


Explain indexed views?

555