SQL Dependency Tracker 3

SQL Server 2025 Data Type and Index Notes

In SQL Dependency Tracker, two behaviors have been observed when working with SQL Server 2025 features, specifically with newly introduced data types like VECTOR and JSON.

Data Type Display

Columns using VECTOR or JSON may appear with an internal system-schema formatting in the Dependency Tracker interface.

Examples:

  • VECTOR displayed as [sys].[vector]
  • JSON displayed as [sys].[json]

This is purely a display issue and does not affect the underlying database objects.

Script Generation for Indexes

When generating SQL scripts, indexes defined on VECTOR or JSON columns may be scripted as non clustered indexes instead of the vector index structure introduced in SQL Server 2025.

This affects only the generated script, not the actual index definition stored in the database.



Didn't find what you were looking for?