Follow SQLMaster on Twitter
Welcome to SqlServer-QA.net Sign in | Help

TSQL to return internal table columns and column data types?

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;

 

Published Thursday, November 01, 2007 7:26 AM by SQL Master

Comments

# TSQL to return internal table columns and column data types?

SELECT SCHEMA_NAME(itab.schema_id) AS schema_name ,itab.name AS internal_table_name ,typ.name AS column_data_type

Thursday, November 01, 2007 8:08 AM by Other SQL Server Blogs around the Web

# TSQL to return internal table columns and column data types?

SELECT SCHEMA_NAME(itab.schema_id) AS schema_name ,itab.name AS internal_table_name ,typ.name AS column_data_type

Thursday, November 01, 2007 9:00 AM by SSQA.net - SqlServer-QA.net
Anonymous comments are disabled