April 25, 2012

sp_help_spatial_geography_index_xml (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_help_spatial_geography_index_xml(nvarchar @tabname
, nvarchar @indexname
, tinyint @verboseoutput
, hierarchyid @query_sample)

MetaData:

 CREATE PROC sys.sp_help_spatial_geography_index_xml  
(
@tabname NVARCHAR(776), -- the TABLE to check for indexes
@indexname SYSNAME, -- the INDEX name
@verboseoutput TINYINT, -- OUTPUT all properties
@query_sample GEOGRAPHY, -- query window object
@xml_output XML OUTPUT -- XML variable to OUTPUT
)
AS
BEGIN
EXEC sys.sp_help_spatial_geography_index_helper @tabname, @indexname, 1, @xml_output OUTPUT, @verboseoutput, @query_sample
END

No comments:

Post a Comment

Total Pageviews