desc <table

how to know description of a table in sqlserver 2000

Question Posted / srinivas

Answer Posted / srinivas

desc <table_name>

Is This Answer Correct ?

2 Yes

6 No

Please Help Members By Posting Answers For Below Questions

Explain the difference between functions and stored procedures in sql server?

960

How you can change a cross join into an inner join?

939

How many instances per computer are there in sql server 2000?

1044

What is the syntax to execute the sys.dm_db_missing_index_details?

1000

Do you know what is difference between index seek vs. Index scan?

931

Give me a SQL Query to find out the second largest company?

1147

How to convert a unicode strings to non-unicode strings?

1077

Explain for xml explicit mode?

957

What type of locking occurs during the snapshot generation? : sql server replication

1317

What is the process of indexing?

985

Explain intellisense for query editing

1014

Explain about builtinadministrator?

1033

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

944

can a database be shrunk to 0 bytes, if not, why? : Sql server administration

1174

Explain the different types of joins?

967