View: Temp_Columns_View | |||
View definition | |||
CREATE VIEW cdal.Temp_Columns_View AS SELECT C.object_id AS object_id , C.name AS COLUMN_NAME , C.column_id - 1 AS COLUMN_INDEX , T.name AS TYPE_NAME , C.is_identity AS IS_AUTO_NUM , C.is_computed AS IS_COMPUTED , C.is_nullable AS IS_NULLABLE , CONVERT(BIT, CASE WHEN C.default_object_id <> 0 THEN 1 ELSE 0 END) AS HAS_DEFAULT , CONVERT(INT, CASE WHEN C.max_length = -1 THEN -1 WHEN T.name IN ( 'ntext' ) THEN 1073741823 WHEN T.name IN ( 'text', 'image' ) THEN 2147483647 WHEN T.name IN ( 'nchar', 'nvarchar' ) THEN C.max_length / 2 WHEN T.name IN ( 'char', 'varchar', 'varbinary', 'timestamp', 'uniqueidentifier' ) THEN C.max_length ELSE C.precision END) AS COLUMN_PRECISION , CONVERT(INT, C.scale) COLUMN_SCALE , C.collation_name AS COLUMN_COLLATION FROM tempdb.sys.columns AS C WITH ( NOLOCK ) INNER JOIN tempdb.sys.types AS T WITH ( NOLOCK ) ON C.system_type_id = T.system_type_id AND T.system_type_id = T.user_type_id; | |||