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

Categories >> Software >> Databases >> SQL Server
Suggest New Category

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

Question Posted / siva

10 Answers
17738 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

Answer / anil panwar

SP_help < table_name>

Is This Answer Correct ?

54 Yes

1 No

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

Answer / vidit tyagi

sp_help <tablename>

Is This Answer Correct ?

10 Yes

2 No

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

Answer / krishnaraj

sp_help '<TABLE NAME>'

Is This Answer Correct ?

4 Yes

1 No

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

Answer / erwin suryana

sp_columns <table_name>

Is This Answer Correct ?

5 Yes

3 No

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

Answer / ram

sp_help <table name>

Is This Answer Correct ?

2 Yes

1 No

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

Answer / sathish

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

Select * from information_schema.columns where table_name =
xyz

Is This Answer Correct ?

1 Yes

0 No

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

Answer / r.rajesh

sp_columns table_name

Is This Answer Correct ?

1 Yes

1 No

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

Answer / sagar

Select TableName and then press ALT+F1 means highlight tablename

Is This Answer Correct ?

0 Yes

0 No

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

Answer / murli manohar

sp_tables @table_type = "'TABLEName'"

Is This Answer Correct ?

5 Yes

9 No

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

Answer / justus

sp_helptext <tablename>

Is This Answer Correct ?

2 Yes

7 No

Post New Answer