sys.vector_indexes (Transact-SQL)

SQL Server 2025 (17.x) Preview

Contains a row per vector index.

Column name	Data type	Description
object_id	int	Reference to sys.indexes
index_id	int	Reference to sys.indexes
metric	varchar(20)	Type of vector index (DiskANN only for now)
type_desc	varchar(20)	Metric used to create the vector index
build_parameters	nvarchar(max)	Internal usage only

Permissions

The visibility of the metadata in catalog views is limited to securables that a user either owns, or on which the user was granted some permission. For more information, see Metadata Visibility Configuration.

Examples

The following example returns all indexes for the table [dbo].[[wikipedia_articles_embeddings] used in the DiskANN sample available in the https://github.com/Azure-Samples/azure-sql-db-vector-search GitHub sample repo.

select 
	vi.obj_id,
	vi.index_id,
	vi.index_type,
	vi.dist_metric,
	vi.build_parameters
from 
	sys.indexes i 
inner join
	sys.vector_indexes as vi on vi.obj_id = i.object_id and vi.index_id = i.index_id
where 
	obj_id = object_id('[dbo].[wikipedia_articles_embeddings]')

Next steps

Object Catalog Views (Transact-SQL)
Catalog Views (Transact-SQL)
sys.indexes (Transact-SQL)
CREATE VECTOR INDEX (Transact-SQL)