sp_help '<TABLE NAME>'

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

Question Posted / krishnaraj

Answer Posted / krishnaraj

Is This Answer Correct ?

4 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Explain iaas, paas and saas?

How to check if stored procedure is running in sql server?

1121

What is the recursive stored procedure in sql server?

1073

Explain the truncate command? : SQL Server Architecture

1228

How to check parameter value in stored procedure sql server?

1026

What is store procedure? How do they work? When do you use?

990

What is the purpose of self join?

1035

Why does sql studio use a single registered database repository? : sql server management studio

1036

What is index, cluster index and nonclustered index?

1046

How do you handle datasets larger than 50 gb?

164

What is the use of sign function?

1191

Define primary key?

1195

What happens to a statement batch if there is a compilation error?

1009

Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?

998

How to access the deleted record of an event?

1091