sp_columns <table

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

Question Posted / erwin suryana

Answer Posted / erwin suryana

sp_columns <table_name>

Is This Answer Correct ?

5 Yes

3 No

Please Help Members By Posting Answers For Below Questions

How many databases can we create in a single server?

207

Explain index in sql server?

995

How to trouble shoot if unable to connect SQL Server

1973

What are the properties of sub-query?

1061

Differentiate between a local and a global temporary table?

941

How can we solve concurrency problems?

1035

How to read data in a table with "select" statements?

952

What are three major types of constraints?

1096

What is the parse query button used for?

1015

How do you handle datasets larger than 50 gb?

162

what is a transaction? : Sql server database administration

975

what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration

953

Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?

999

What stored by the model?

1032

explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

914