how to know description of a table in sqlserver 2000

Answer Posted / ksantosha

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

Is This Answer Correct ?    11 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the advantages of sql stored procedure?

526


Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security

572


What is tablix?

115


What are the differences between clustered and non-clustered index?

532


What are the different types of upgrades that can be performed in sql server?

685






Do you know the different ddl commands in sql?

582


What is the difference between lock, block and deadlock? : sql server database administration

558


Explain few examples of stored procedure over triggers?

509


what is the main function of a query parameter?

111


What is the difference between an index and a unique index?

540


How many types of attribute relationships are there? : sql server analysis services, ssas

575


How efficient you are in oracle and SQL server?

630


I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration

670


Explain a differential backup?

567


how many bits ip address consist of? : Sql server database administration

447