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

Can you explain what is sql server english query?

996

Why do you need a sql server?

1108

Explain partitioned view?

1076

What is the importance of three tier architecture?

1093

What is tcl in sql server?

1122

List out the different types of locks available in sql server?

978

How many types of attribute relationships are there? : sql server analysis services, ssas

1079

Explain the microsoft sql server delete command?

1018

When do you think a developer should use sql server-based cursors?

1047

How can I get data from a database on another server?

995

Write a code to select distinct records without using the DISTINCT keyword.

1114

What is bcp? When does it used?

976

Explain Geography datatype in SQL Server

1129

What is table constraint?

992

How to link tables in sql server?

935