Query for select field names,data types etc..

Get   names, data types, description, and size of fields in table

While making documentation for Db tables, we require its field names, data types, size, and its descriptions etc system info.

So that u can just copy and paste it from result pane of sql server instead of doing copy paste from modifying table

Here is sql -query for same…Hope u found it interesting…


[Column Name] = c.name,

sysTypes.name AS DataType  ,

c.is_nullable As Nullable,

c.Max_Length AS Length ,

[Description] = ex.value


sysTypes,sys.columns c


sys.extended_properties ex


ex.major_id = c.object_id

AND ex.minor_id = c.column_id


c.system_type_id= sysTypes.xtype  AND

OBJECT_NAME(c.object_id) = TableName and sysTypes.name <> ‘sysname’


BY OBJECT_NAME(c.object_id), c.column_id


2 thoughts on “Query for select field names,data types etc..

  1. Thank you, I’ve just been looking for information approximately this topic for a while and yours is the greatest I have came upon till now. However, what in regards to the conclusion? Are you sure about the source?

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s