Edit

Share via


sys.vector_indexes (Transact-SQL)

Applies to: SQL Server 2025 (17.x) Preview

Contains a row per vector index.

Column name Data type Description
<inherited columns> Inherits columns from sys.indexes.
vector_index_type varchar(20) Type of vector index (DiskANN only for now)
distance_metric 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
  object_id,
  index_id,
  vector_index_type,
  distance_metric,
  build_parameters
FROM
  sys.vector_indexes AS vi
WHERE
  object_id = OBJECT_ID('[dbo].[wikipedia_articles_embeddings]')