add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE tab(
id INT PRIMARY KEY,
c INT INDEX filtered (c) WHERE c > 10,
b VARCHAR(10) NOT NULL INDEX idx_tab_b,
d VARCHAR(20) NOT NULL,
INDEX my_index NONCLUSTERED(d)
);
SELECT * FROM sys.indexes WHERE OBJECT_ID = OBJECT_ID('tab')
object_id name index_id type type_desc is_unique data_space_id ignore_dup_key is_primary_key is_unique_constraint fill_factor is_padded is_disabled is_hypothetical is_ignored_in_optimization allow_row_locks allow_page_locks has_filter filter_definition compression_delay suppress_dup_key_messages auto_created optimize_for_sequential_key
581577110 PK__tab__3213E83F6EB2D303 1 1 CLUSTERED True 1 False True False 0 False False False False True True False null null False False False
581577110 my_index 2 2 NONCLUSTERED False 1 False False False 0 False False False False True True False null null False False False
581577110 idx_tab_b 3 2 NONCLUSTERED False 1 False False False 0 False False False False True True False null null False False False
581577110 filtered 4 2 NONCLUSTERED False 1 False False False 0 False False False False True True True ([c]>(10)) null False False False