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 are user defined datatypes and when you should go for them? : Sql server database administration

1061

What is the use of RDBMS?

1054

What does REVERT do in SQL Server 2005?

1009

What is sql language?

1228

What are subqueries in sql server? Explain its properties.

1067

Explain sql server authentication modes?

1184

How to insert stored procedure result into temporary table?

1062

Does windows server 2016 come with sql server?

984

What is mean by candidate key?

1059

Define cursor locking

1058

Difference between group by clause and having clause in SQL?

1022

Explain “@@rowcount” and “@@error” in sql server?

1128

What is the use of keyword with encryption. Create a store procedure with encryption?

994

What is the sql profiler?

998

Why do we use sql limitations? Which constraints can we use while making a database in sql?

1123