I'm trying to pull wheteher an index is set for ONLINE = ON/OFF ? Something to this effect ...
--Get index details
Select tbl.name as TableName, tbl.object_id as ObjectID,
ind.name as IndexName, ind.index_id as IndexID,
sch.name as SchemaName, par.partition_number as PartitionNo
--, ONLINE = ON/OFF ?
from sys.tables tbl
inner join sys.indexes ind on tbl.object_id = ind.object_id
inner join sys.partitions par on ind.object_id = par.object_id and ind.index_id = par.index_id
inner join sys.schemas sch on sch.schema_id = tbl.schema_id
where tbl.type = 'U' and
tbl.name not like 'sys%' and
ind.index_id > 0 --ignore heap
I can not find this setting in the above system tables or in sysindexes, sys.columns, sys.index_columns. Can somebody please explain to me how I must go about to get this ONLINE info ?
Thanks in advance