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 to get the rowid/rownumbes of a table in sqlserver

7 Answers   IBM,

What is a NOLOCK?

3 Answers   NA,

How do I clean up sql server transaction log?

0 Answers  

Do you know what are pages and extents? : SQL Server Architecture

0 Answers  

What Are Three Rules to Use UNION IN SQL SERVER

1 Answers  

What happens if null values are involved in string operations?

0 Answers  

What is a periodical index?

0 Answers  

What is self contained sub query?

0 Answers  

What do you mean by authentication modes in sql server?

0 Answers  

Explain about temporary stored procedure?

0 Answers  

Explain the properties of a relational table?

0 Answers  

Define the term DML, DDL and DTL?

1 Answers