Answer / ksantosha

Dear Srinivas,
desc using in oracle not in Sql Server.
sp_help <table_name> is correct answer for Sql server

Answer / kmbkrishnan

sp_help <table_name>

Answer / ritesh

sp_ help table name
is the correct answer , above two answer is correct

Answer / rajeev

by pressing alt+f1 we also get the description of the table

Answer / punithalakshmi

sp_help is the correct answer.

Answer / sharif

Yes The Ksanthosha Given the Right Answer!

SP_HELP TABLE_NAME

This will gives the descriptin about the given TABLE_NAME

Answer / hameed

To get the description of the table execute this query in
the query editor
sp_help table_name

Answer / srinivas

desc <table_name>

What is difference between view and materialized view?

0 Answers  

What is a db view?

0 Answers  

How to list all tables having unique constraints in any of the columns in a database.

1 Answers  

can we call stored Procedure in Function in Sql Server 2000 and vice versa.

3 Answers   C3I, eSoft, iPRO Solutions, Wipro,

what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

0 Answers  

What is a trace frag?

0 Answers  

Any one plz send me SQL Server Developer/DBA resume for 4 years experience

0 Answers  

Explain the first normal form(1nf)?

0 Answers  

What is t-sql script to take database offline – take database online.

0 Answers  

What is difference between Datepart() and Datename() in SqlServer?

0 Answers   Infosys,

What is the purpose of floor function?

0 Answers  

The Difference between 'Count' and 'Count(*)'

13 Answers