Answer / anil panwar

SP_help < table_name>

Answer / vidit tyagi

sp_help <tablename>

Answer / krishnaraj

sp_help '<TABLE NAME>'

Answer / erwin suryana

sp_columns <table_name>

Answer / ram

sp_help <table name>

Answer / sathish

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

Select * from information_schema.columns where table_name =
xyz

Answer / r.rajesh

sp_columns table_name

Answer / sagar

Select TableName and then press ALT+F1 means highlight tablename

Answer / murli manohar

sp_tables @table_type = "'TABLEName'"

Answer / justus

sp_helptext <tablename>

How do I open a .db file?

0 Answers  

How do I create a partition table in sql server?

0 Answers  

Explain in brief how sql server enhances scalability of the database system?

0 Answers  

What is clustered primary key?

0 Answers  

Why we use functions in sql server?

0 Answers  

Does a server store data?

0 Answers  

What is the difference between Stored Procedure , Function and Package, 1. how many blocks in Package and what are they.

5 Answers   IBM,

What is the use of set nocount on/off statement?

0 Answers  

Explain transaction isolation levels in sql server?

0 Answers  

you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration

0 Answers  

What is temporary stored procedure?

0 Answers  

What is better - 2nd Normal form or 3rd normal form? Why?

2 Answers   TCS, TPK,