April 25, 2012

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

MetaData:

 CREATE PROC sys.sp_help_spatial_geography_index  
(
@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
)
AS
BEGIN
EXEC sys.sp_help_spatial_geography_index_helper @tabname, @indexname, 0, null, @verboseoutput, @query_sample
END

No comments:

Post a Comment

Total Pageviews