sp_columns <table

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

Question Posted / erwin suryana

10 Answers
18069 Views
I also Faced
E-Mail Answers

Answer Posted / erwin suryana

sp_columns <table_name>

Is This Answer Correct ?

5 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is an index in sql?

1006

what is checksum in sql server.........???

1686

Can a table be moved to different filegroup?

976

How do I view a procedure in sql server?

989

How to get all stored procedures in sql server?

1001

What are data regions?

135

What is spid in sql server profiler?

1106

optimization techinques

2675

Is resultset an interface?

967

Which is better statement or preparedstatement?

925

Which are the olap features?

957

How to use values from other tables in update statements in ms sql server?

1117

Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.

1847

do views contain data ?

968

What are user defined functions in ms sql server?

999