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>

What is Covering Indexes? Plz explain with example

3 Answers  

What should be the fill factor for indexes created on tables? : sql server database administration

0 Answers  

Can a synonym name of a table be used instead of a table name in a select statement?

0 Answers  

What does truncate do?

0 Answers  

how do you test proper tcp/ip configuration windows machine? : Sql server database administration

0 Answers  

how to copy only distinct data into another table which is not already exist in database?

2 Answers   Spectra,

What is molap and its advantage? : sql server analysis services, ssas

0 Answers  

What are the properties of primary key?

0 Answers  

If we use where clause in the left outer join then how the query would behave/act?

1 Answers  

Explain index in sql server?

0 Answers  

Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)

0 Answers  

Why is replication required on the sql server?

0 Answers