Hi
Check this...
SELECT ORDINAL_POSITION , Column_Name,
CASE WHEN Data_Type = 'Numeric' THEN Data_type + '('+CONVERT(VARCHAR,Numeric_Precision)+','+CONVERT(VARCHAR,Numeric_Scale) +')'
WHEN Data_Type = 'Varchar' OR Data_Type = 'Char' THEN Data_type + '('+CONVERT(VARCHAR,Character_Maximum_Length)+')'
ELSE Data_type END 'Data Type',
CASE WHEN IS_Nullable = 'NO' THEN 'NN' ELSE 'N' END 'NUll/NOT NULL'
FROM Information_Schema.Columns
WHERE table_name = 'Table_Name'
ORDER BY TABLE_NAME , ORDINAL_POSITION