sp indexes system procedure

GPTKB entity

Statements (97)
Predicate Object
gptkbp:instanceOf system stored procedure
https://www.w3.org/2000/01/rdf-schema#label sp indexes system procedure
gptkbp:parameter @table_name
@table_owner
@table_qualifier
gptkbp:result index XML information
index column information
index data space information
index filter definition
index information
index partition information
index spatial information
index type information
index uniqueness information
indexed view information
table information
view information
gptkbp:returnsColumns TYPE
TABLE_NAME
TABLE_OWNER
PAGES
ALLOW_PAGE_LOCKS
ALLOW_ROW_LOCKS
ASC_OR_DESC
AUTO_CREATED
BUCKET_COUNT
CARDINALITY
COLUMN_NAME
COMPRESSED
COMPRESSION_DESC
COMPRESSION_TYPE_DESC
DATA_SPACE_ID
DROPPED_COLUMNS_ID
DURATION
FILL_FACTOR
FILTER_CONDITION
FILTER_DEFINITION
HAS_FILTER
HAS_PERSISTED_SAMPLE
IGNORE_DUP_KEY
INDEX_ID
INDEX_NAME
INDEX_QUALIFIER
INDEX_TYPE_DESC
INTEGRATED_INDEX
IS_AUTO_CREATED_INDEX
IS_COLUMNSTORE
IS_COLUMNSTORE_ARCHIVE
IS_COLUMNSTORE_ARCHIVE_INDEX
IS_COLUMNSTORE_INDEX
IS_COMPRESSED_INDEX
IS_DISABLED
IS_DISABLED_INDEX
IS_EDGE
IS_EXTERNAL
IS_FILTERED_INDEX
IS_FULLTEXT_INDEX
IS_GRAPH
IS_HASH
IS_HASH_INDEX
IS_HYPOTHETICAL
IS_HYPOTHETICAL_INDEX
IS_JSON
IS_MEMORY_OPTIMIZED
IS_MEMORY_OPTIMIZED_INDEX
IS_NODE
IS_NOT_FOR_REPLICATION
IS_OPTIMIZED_FOR_SEQUENTIAL_KEY
IS_PRIMARY_KEY
IS_PRIMARY_XML_INDEX
IS_REBUILD_PENDING
IS_RESUMABLE
IS_RESUMABLE_INDEX
IS_SECONDARY_XML_INDEX
IS_SPATIAL
IS_SPATIAL_INDEX
IS_SYSTEM_VERSIONED_TEMPORAL_HISTORY
IS_SYSTEM_VERSIONED_TEMPORAL_TABLE
IS_UNIQUE
IS_UNIQUE_CONSTRAINT
IS_XML
IS_XML_INDEX
OBJECT_ID
OPTIMIZED_FOR_SEQUENTIAL_KEY
ORDINAL_POSITION
PAD_INDEX
PARTITION_COUNT
PARTITION_NUMBER
PERSISTED_SAMPLE_PERCENT
RESUME_STATE
RESUME_STATE_INDEX
STATISTICS_INCREMENTAL
STATISTICS_NORECOMPUTE
TABLE_QUALIFIER
gptkbp:usedIn gptkb:Microsoft_SQL_Server
gptkbp:bfsParent gptkb:Sybase_SQL_dialect
gptkbp:bfsLayer 7