View: Temp_Column_Characteristics_View
View definition
CREATE VIEW cdal.Temp_Column_Characteristics_View
AS
SELECT O.name AS TABLE_NAME ,
CASE O.type
WHEN 'U' THEN 'BASE TABLE'
WHEN 'V' THEN 'VIEW'
END AS TABLE_TYPE ,
CV.COLUMN_NAME ,
CV.COLUMN_INDEX ,
CV.TYPE_NAME ,
CV.IS_AUTO_NUM ,
CV.COLUMN_PRECISION ,
CV.COLUMN_SCALE ,
CV.COLUMN_COLLATION ,
CV.IS_NULLABLE ,
CASE WHEN CV.IS_COMPUTED = 1
OR O.type = 'V'
OR CV.IS_AUTO_NUM = 1
OR CV.TYPE_NAME = 'rowversion'
OR CV.TYPE_NAME = 'timestamp' THEN 'DISALLOWED'
WHEN CV.IS_NULLABLE = 0
AND CV.HAS_DEFAULT = 0 THEN 'REQUIRED'
ELSE 'OPTIONAL'
END AS ON_INSERT
FROM tempdb.sys.objects AS O WITH ( NOLOCK )
INNER JOIN cdal.Temp_Columns_View CV WITH ( NOLOCK ) ON O.object_id = CV.object_id
WHERE O.type IN ( 'U', 'V' )
AND O.is_ms_shipped = 0;