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

What is the difference between indexing and hashing?

1096

Explain system functions or built-in functions? What are different types of system functions?

929

What is clustered vs nonclustered index?

894

Explain for xml explicit mode?

923

How to write a query with an inner join in ms sql server?

1009

Difference between drill down and drill through report.

906

What is a mixed extent?

961

What are data resources?

859

What is the difference between a unique key and primary key?

904

What is the difference between Stored Procedures and triggers?

1046

What is a scheduled job or what is a scheduled task?

920

What is the use of “join” in sql server?

1030

Does partitioning improve performance sql server?

911

What is server-level principal?

120

Tell me about normalization in DBMS.

955