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 sql or structured query language?

1096

What is a field in a table?

997

When I delete any data from a table, does the sql server reduce the size of that table?

974

Which rendering formats are affected by the pagesize properties?

138

What is encryption key?

119

What is a rownum?

909

What is triggers in ms sql server?

1067

How each E-R model constructs can be mapped to the relational model?

941

How is SQL Azure different than SQL server?

223

Explain about service Broker functions?

993

How will you hide an attribute? : sql server analysis services, ssas

910

What is a field name?

924

What is the difference between getdate and sysdatetime?

956

What is sql server english query?

1061

List the data types available in mssql?

974