sp_columns table

how can i view structure of table in sql server? tell me
that query.

Question Posted / r.rajesh

Answer Posted / r.rajesh

sp_columns table_name

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is difference between sql and sql server?

934

What is triggers and its types?

950

How secure is sql server database?

948

Explain concepts of analysis services?

890

What is the purpose of optimization?

948

How to get the definition of a view out of the sql server?

936

What does sql server mean?

967

Can sql servers linked to other servers?

970

How to download microsoft sql server 2005 express edition?

973

Explain about system database?

998

What is a covering index?

916

How to query multiple tables jointly?

916

What is "scheduled jobs" or "scheduled tasks"?

907

How you can get the list of largest tables in a database?

939

what is database replication? : Sql server database administration

983