SELECT COLUMN_NAME AS [Field Name] , (DATA_TYPE + CASE WHEN CHARACTER_MAXIMUM_LENGTH IS NOT NULL THEN '(' + CONVERT(VARCHAR(20), CHARACTER_MAXIMUM_LENGTH) + ')' ELSE '' END ) AS [Field Type] FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'SOME TABLE NAME'SELECT COLUMN_NAME AS [Field Name] , (DATA_TYPE + CASE WHEN CHARACTER_MAXIMUM_LENGTH IS NOT NULL THEN '(' + CONVERT(VARCHAR(20), CHARACTER_MAXIMUM_LENGTH) + ')' ELSE '' END ) AS [Field Type] FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = ......
I apologize for some feedbacks on my posts that didn't make through. It's a simple security precaution on my part that if your feedback contains any link, I do not let it through. If you have a link you want people to know or to check out, post on they can search for it with Google or Bing.
Thank you.