Hehe. Guess I'll wait till then to try it.



>Sorry, it's SQL 2008 feature <g>.
>
>>Thanks Sergey, but I'm curious about the 'LEGT JOIN' part. vbg :)
>>
>>
>>
>>
>>
>>>The Column Size, Precision, Null/Not Null is in sys.colums
>>>
>>>

>>>SELECT t.name AS TableNAme, c.name AS ColName, c.column_id AS Sequence,
>>>		c.max_length, c.precision, c.scale, c.is_nullable,
>>>		ep.value	
>>>	FROM sys.tables t
>>>	JOIN sys.columns c
>>>		ON c.object_id = t.object_id
>>>	LEFT JOIN sys.extended_properties ep
>>>		ON ep.major_id = t.object_id
>>>			AND ep.minor_id = c.column_id
>>>