xSQL Schema Compare SDK for SQL Server version 12
SqlSpatialIndex Class Members
Properties  Methods 


The following tables list the members exposed by SqlSpatialIndex.

Public Constructors
 NameDescription
Public ConstructorSqlSpatialIndex ConstructorInitializes a new instance of the SqlSpatialIndex class with the specified id, name and table.  
Top
Public Properties
 NameDescription
Public PropertyBoundingBoxXMax Gets or sets the x-coordinate of the upper right corner of the bounding box.  
Public PropertyBoundingBoxXMin Gets or sets the x-coordinate of the lower left corner of the bounding box.  
Public PropertyBoundingBoxYMax Gets or sets the y-coordinate of the upper right corner of the bounding box.  
Public PropertyBoundingBoxYMin Gets or sets the y-coordinate of the lower left corner of the bounding box.  
Public PropertyCellsPerObject Gets or sets the max number of cells used by the cell-per-object tessellation.  
Public PropertyColumns Gets the collection of columns that participate in the index. (Inherited from xSQL.Schema.SqlServer.IndexBase)
Public PropertyDataCompression Gets or sets the index data compression. (Inherited from xSQL.Schema.SqlServer.IndexBase)
Public PropertyFileGroup Gets or sets the filegroup in which the index is created.  
Public PropertyFillFactor Gets or sets the index fill factor. (Inherited from xSQL.Schema.SqlServer.IndexBase)
Public PropertyFullName Gets the full name of the entity formatted as schema.name. If the entity has no schema, only the name is returned. (Inherited from xSQL.Schema.Core.Entity)
Public PropertyFullNameDelimited Gets the delimited full name for the entity formatted as [schema].[name]. (Inherited from xSQL.Schema.SqlServer.SqlEntity)
Public PropertyFullyQualifyingName Gets the fully-qualifying name of the index. The name is formatted as parent_name.index_name. (Inherited from xSQL.Schema.SqlServer.IndexBase)
Public PropertyFullyQualifyingNameDelimited Gets the fully-qualifying name of the index. The name is formatted as [parent_name].[index_name] (Inherited from xSQL.Schema.SqlServer.IndexBase)
Public PropertyId Gets or sets a unique id for the entity. (Inherited from xSQL.Schema.Core.Entity)
Public PropertyIsPadded Gets or sets the value that indicates whether the PAD_INDEX is ON. (Inherited from xSQL.Schema.SqlServer.IndexBase)
Public PropertyIsPageLockEnabled Gets or sets the value that indicates whether the ALLOW_PAGE_LOCKS is ON. (Inherited from xSQL.Schema.SqlServer.IndexBase)
Public PropertyIsRowLockEnabled Gets or sets the value the indicates whether the ALLOW_ROW_LOCKS is ON. (Inherited from xSQL.Schema.SqlServer.IndexBase)
Public PropertyLevel1Grid Gets or sets the density of the level-1 grid of the index.  
Public PropertyLevel2Grid Gets or sets the density of the level-2 grid of the index.  
Public PropertyLevel3Grid Gets or sets the density of the level-3 grid of the index.  
Public PropertyLevel4Grid Gets or sets the density of the level-4 grid of the index.  
Public PropertyName Gets or sets the name of the entity. (Inherited from xSQL.Schema.Core.Entity)
Public PropertyNoAutomaticStatsRecompute Gets or sets the value that indicates whether the STATISTICS_NORECOMPUTE is ON. (Inherited from xSQL.Schema.SqlServer.IndexBase)
Public PropertyParent Gets the parent entity of this entity. (Inherited from xSQL.Schema.Core.Entity)
Public PropertySchema Gets or set the entity schema. (Inherited from xSQL.Schema.Core.Entity)
Public PropertySpatialIndexType Gets or sets type of the spatial index.  
Public PropertySqlDatabaseGets the SqlDatabase to which the entity belongs. (Inherited from xSQL.Schema.SqlServer.SqlEntity)
Public PropertySqlEntityType Gets the type of the entity. (Inherited from xSQL.Schema.SqlServer.SqlScriptableEntity)
Public PropertySqlExtendedProperties Gets the collection of extended properties that belong to the index. (Inherited from xSQL.Schema.SqlServer.IndexBase)
Public PropertyTessellation Gets or sets the spatial index tessellation scheme.  
Top
Public Methods
 NameDescription
Public MethodEqualsOverloaded. Returns true if this instance of the SqlScriptableEntity class is equal to the other object, which should also be an instance of SqlScriptableEntity class. (Inherited from xSQL.Schema.SqlServer.SqlScriptableEntity)
Public MethodGetScript Returns the T-SQL script for this entity with the specified scripting options. (Inherited from xSQL.Schema.SqlServer.SqlScriptableEntity)
Public MethodToString Returns the full name of the entity. (Inherited from xSQL.Schema.Core.Entity)
Top
See Also

Reference

SqlSpatialIndex Class
xSQL.Schema.SqlServer Namespace

 

 


©Copyright 2022 xSQL Software. All Rights Reserved.

Send Feedback