Browse by Tags

• tablename
• tsql

TSQL to return internal table columns and column data types?
01 November 07 07:26 AM | SQL Master | 2 Comments   

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 Read More...

Filed under: tsql, sql server, tablename, internal tables, select