The meta data is from an SQL 2012 Server.
I have posted alot more, find the whole list here.
Goto Definition or MetaData
Definition:
sys.sp_table_type_columns_100_rowset(nvarchar @table_name, nvarchar @table_schema
, nvarchar @column_name)
MetaData:
create procedure sys.sp_table_type_columns_100_rowset ( @table_name sysname = NULL, @table_schema sysname = NULL, @column_name sysname = NULL ) as select TABLE_CATALOG = s_cv.TABLE_CATALOG, TABLE_SCHEMA = s_cv.TABLE_SCHEMA, TABLE_NAME = s_cv.TABLE_NAME, COLUMN_NAME = s_cv.COLUMN_NAME, COLUMN_GUID = s_cv.COLUMN_GUID, COLUMN_PROPID = s_cv.COLUMN_PROPID, ORDINAL_POSITION = s_cv.ORDINAL_POSITION, COLUMN_HASDEFAULT = s_cv.COLUMN_HASDEFAULT, COLUMN_DEFAULT = s_cv.COLUMN_DEFAULT, COLUMN_FLAGS = s_cv.COLUMN_FLAGS, IS_NULLABLE = s_cv.IS_NULLABLE, DATA_TYPE = s_cv.DATA_TYPE, TYPE_GUID = s_cv.TYPE_GUID, CHARACTER_MAXIMUM_LENGTH= s_cv.CHARACTER_MAXIMUM_LENGTH, CHARACTER_OCTET_LENGTH = s_cv.CHARACTER_OCTET_LENGTH, NUMERIC_PRECISION = s_cv.NUMERIC_PRECISION, NUMERIC_SCALE = s_cv.NUMERIC_SCALE, DATETIME_PRECISION = s_cv.DATETIME_PRECISION, CHARACTER_SET_CATALOG = s_cv.CHARACTER_SET_CATALOG, CHARACTER_SET_SCHEMA = s_cv.CHARACTER_SET_SCHEMA, CHARACTER_SET_NAME = s_cv.CHARACTER_SET_NAME, COLLATION_CATALOG = s_cv.COLLATION_CATALOG, COLLATION_SCHEMA = s_cv.COLLATION_SCHEMA, COLLATION_NAME = s_cv.COLLATION_NAME, DOMAIN_CATALOG = s_cv.DOMAIN_CATALOG, DOMAIN_SCHEMA = s_cv.DOMAIN_SCHEMA, DOMAIN_NAME = s_cv.DOMAIN_NAME, DESCRIPTION = s_cv.DESCRIPTION, COLUMN_LCID = s_cv.COLUMN_LCID, COLUMN_COMPFLAGS = s_cv.COLUMN_COMPFLAGS, COLUMN_SORTID = s_cv.COLUMN_SORTID, COLUMN_TDSCOLLATION = s_cv.COLUMN_TDSCOLLATION, IS_COMPUTED = s_cv.IS_COMPUTED, SS_XML_SCHEMACOLLECTION_CATALOGNAME = s_cv.SS_XML_SCHEMACOLLECTION_CATALOGNAME, SS_XML_SCHEMACOLLECTION_SCHEMANAME = s_cv.SS_XML_SCHEMACOLLECTION_SCHEMANAME, SS_XML_SCHEMACOLLECTIONNAME = s_cv.SS_XML_SCHEMACOLLECTIONNAME, SS_UDT_CATALOGNAME = s_cv.SS_UDT_CATALOGNAME, SS_UDT_SCHEMANAME = s_cv.SS_UDT_SCHEMANAME, SS_UDT_NAME = s_cv.SS_UDT_NAME, SS_UDT_ASSEMBLY_TYPENAME= s_cv.SS_UDT_ASSEMBLY_TYPENAME, SS_IS_SPARSE = s_cv.SS_IS_SPARSE, SS_IS_COLUMN_SET = s_cv.SS_IS_COLUMN_SET from sys.spt_table_type_columns_view s_cv where (@table_name is null or s_cv.TABLE_NAME = @table_name) and (@table_schema is null or schema_id(@table_schema) = s_cv.schema_id) and (@column_name is null or s_cv.COLUMN_NAME = @column_name) order by 1, 2, 3, 7
No comments:
Post a Comment