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>

to explain sql server 2000 architecture & authentication

1 Answers   HCL,

What is a Linked Server?

1 Answers  

What is difference between views and tables?

0 Answers  

What is collation sensitivity?

0 Answers  

How would you choose between a clustered and a non-clustered index?

0 Answers  

What is normalization process?

0 Answers  

What is openrowset sql server?

0 Answers  

Can we rollback records deleted by a truncate statement?

3 Answers   CarrizalSoft Technologies, United Healthcare,

How can u convert the Date to String?

6 Answers   Microsoft, TCS,

How to create an multi-statement table-valued function?

0 Answers  

What is use of @@ spid in sql server?

0 Answers  

How can u get the number of pupils connecting the database?

1 Answers   Cap Gemini,