Dear Srinivas, desc using in oracle not in Sql Server. sp_help <table

how to know description of a table in sqlserver 2000

Question Posted / ksantosha

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

Please Help Members By Posting Answers For Below Questions

Which Model uses the SET concept

944

How to update values in a table with update statements in ms sql server?

971

How to achieve Paging of records in SQL SERVER?

1056

What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas

938

Do you know exporting and importing utility?

985

What are cursors and when they are useful?

1030

What is serializable?

1001

Explain how to use linked server?

936

Where can you find the error log information? : sql server database administration

990

How to generate create procedure script on an existing stored procedure?

949

Do you know nested transaction?

913

What does it mean to normalize data?

903

what is create database syntax? : Sql server database administration

1060

How can I check that whether automatic statistic update is enabled or not?

1002

Why would you use sql agent?

1228