SQL Server Performance

TSQL to return internal table columns and column data types?

Discussion in 'Other SQL Server Blogs around the Web' started by Anonymous, Nov 1, 2007.

  1. Anonymous New Member

    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">

Share This Page