how to get schema of table in sql server

sid

Member

120 Points

9 Posts

Hi,

how to get schema of table in sql server?

Views: 8757
Total Answered: 1
Total Marked As Answer: 0
Posted On: 04-Jun-2015 10:39

Share:

Answers

Brian

Moderator

2232 Points

14 Posts

Hi Sid,

Use the INFORMATION_SCHEMA.COLUMNS view allows you to get information about all columns in a table within a database as:

SELECT *

FROM INFORMATION_SCHEMA.COLUMNS

WHERE TABLE_NAME='TABLENAME'

Posted On: 04-Jun-2015 20:23

Discussion

MVC Design pattern

No Active User!