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_provider_types_100_rowset(smallint @data_type, tinyint @best_match)
MetaData:
create procedure sys.sp_provider_types_100_rowset ( @data_type smallint = null, @best_match tinyint = null ) as select TYPE_NAME = s_ptv.TYPE_NAME, DATA_TYPE = s_ptv.DATA_TYPE, -- Used by Katmai clients COLUMN_SIZE = s_ptv.COLUMN_SIZE, LITERAL_PREFIX = s_ptv.LITERAL_PREFIX, LITERAL_SUFFIX = s_ptv.LITERAL_SUFFIX, CREATE_PARAMS = s_ptv.CREATE_PARAMS, IS_NULLABLE = s_ptv.IS_NULLABLE, CASE_SENSITIVE = s_ptv.CASE_SENSITIVE, SEARCHABLE = s_ptv.SEARCHABLE, UNSIGNED_ATTRIBUTE = s_ptv.UNSIGNED_ATTRIBUTE, FIXED_PREC_SCALE = s_ptv.FIXED_PREC_SCALE, AUTO_UNIQUE_VALUE = s_ptv.AUTO_UNIQUE_VALUE, LOCAL_TYPE_NAME = s_ptv.LOCAL_TYPE_NAME, MINIMUM_SCALE = s_ptv.MINIMUM_SCALE, MAXIMUM_SCALE = s_ptv.MAXIMUM_SCALE, GUID = s_ptv.GUID, TYPELIB = s_ptv.TYPELIB, VERSION = s_ptv.VERSION, IS_LONG = s_ptv.IS_LONG, BEST_MATCH = s_ptv.BEST_MATCH, IS_FIXEDLENGTH = s_ptv.IS_FIXEDLENGTH from sys.spt_provider_types_view s_ptv where (@data_type is null or s_ptv.DATA_TYPE = @data_type) and (@best_match is null or s_ptv.BEST_MATCH = @best_match) order by 2
No comments:
Post a Comment