April 30, 2012

sp_indexes_rowset_rmt (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_rowset_rmt(nvarchar @table_server
, nvarchar @table_catalog
, nvarchar @table_name
, nvarchar @index_name
, nvarchar @table_schema)

MetaData:

   
create procedure sys.sp_indexes_rowset_rmt
(
@table_server sysname,
@table_catalog sysname = null,
@table_name sysname = null,
@index_name sysname = null,
@table_schema sysname = null
)
as
select
TABLE_CATALOG,
TABLE_SCHEMA,
TABLE_NAME,
INDEX_CATALOG,
INDEX_SCHEMA,
INDEX_NAME,
PRIMARY_KEY,
[UNIQUE],
[CLUSTERED],
[TYPE],
FILL_FACTOR,
INITIAL_SIZE,
NULLS,
SORT_BOOKMARKS,
AUTO_UPDATE,
NULL_COLLATION,
ORDINAL_POSITION,
COLUMN_NAME,
COLUMN_GUID,
COLUMN_PROPID,
[COLLATION],
CARDINALITY,
PAGES,
FILTER_CONDITION,
INTEGRATED = null -- ISSUE these 3 columns must be exported by the server
-- in \yukon\sql\ntdbms\msql\ddl\sysoledb.cpp :
-- const SCHEMA_COLUMNS xCol_INDEXES = {

from
sys.fn_remote_indexes (
@table_server,
@table_catalog,
@table_schema,
@index_name,
null, -- TYPE (index type)
@table_name )
order by 8 desc, 4, 5, 6, 17

No comments:

Post a Comment

Total Pageviews