SELECT SCHEMA_NAME(itab.schema_id) AS schema_name ,itab.name AS internal_table_name ,typ.name AS column_data_type ,col.* FROM sys.internal_tables AS itab JOIN sys.columns AS col ON itab.object_id = col.object_id JOIN sys.types AS typ ON typ.user_type_id = col.user_type_id ORDER BY itab.name, col.column_id;...(<a href="http://sqlserver-qa.net/blogs/t-sql/archive/2007/11/01/2646.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=2646" width="1" height="1">