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 can we check the sql server version?

0 Answers  

What is a print index?

0 Answers  

How do you trace the traffic hitting a sql server?

0 Answers  

What are constraints in microsoft sql server?

0 Answers  

what is differece between union and union all

6 Answers  

can primery key be a non clustered index?

10 Answers  

Which are the third-party tools used in sql server and why would you use them?

0 Answers  

Tell me what is de-normalization and what are some of the examples of it?

0 Answers  

Can you explain various data region available in ssrs with their use?

0 Answers  

Describe about first three Normal forms.

1 Answers   HP,

How to provide Security for package?

1 Answers   Convergys,

How to rebuild master databse?

0 Answers