April 30, 2012

sp_indexes_100_rowset2 (Transact-SQL MetaData) Definition

Please note: that the following source code is provided and copyrighted by Microsoft and is for educational purpose only.
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_indexes_100_rowset2(nvarchar @index_name
, nvarchar @table_schema)

MetaData:

   
create procedure sys.sp_indexes_100_rowset2
(
@index_name sysname = null,
@table_schema sysname = null
)
as
select
TABLE_CATALOG = s_iv.TABLE_CATALOG,
TABLE_SCHEMA = s_iv.TABLE_SCHEMA,
TABLE_NAME = s_iv.TABLE_NAME,
INDEX_CATALOG = s_iv.INDEX_CATALOG,
INDEX_SCHEMA = s_iv.INDEX_SCHEMA,
INDEX_NAME = s_iv.INDEX_NAME,
PRIMARY_KEY = s_iv.PRIMARY_KEY,
[UNIQUE] = s_iv.[UNIQUE],
[CLUSTERED] = s_iv.[CLUSTERED],
[TYPE] = s_iv.[TYPE],
FILL_FACTOR = s_iv.FILL_FACTOR,
INITIAL_SIZE = s_iv.INITIAL_SIZE,
NULLS = s_iv.NULLS,
SORT_BOOKMARKS = s_iv.SORT_BOOKMARKS,
AUTO_UPDATE = s_iv.AUTO_UPDATE,
NULL_COLLATION = s_iv.NULL_COLLATION,
ORDINAL_POSITION = s_iv.ORDINAL_POSITION,
COLUMN_NAME = s_iv.COLUMN_NAME,
COLUMN_GUID = s_iv.COLUMN_GUID,
COLUMN_PROPID = s_iv.COLUMN_PROPID,
[COLLATION] = s_iv.[COLLATION],
CARDINALITY = s_iv.CARDINALITY,
PAGES = s_iv.PAGES,
FILTER_CONDITION = s_iv.FILTER_CONDITION,
INTEGRATED = s_iv.INTEGRATED,
STATUS = s_iv.STATUS

from
sys.spt_indexes_view_100 s_iv

where
(@table_schema is null or schema_id(@table_schema) = s_iv.SCHEMA_ID) and
(@index_name is null or @index_name = s_iv.INDEX_NAME)

order by 8, 10, 4, 5, 6, 17

No comments:

Post a Comment

Total Pageviews