Unknown object type 'VECTOR'
As the message says, for SQL Database Engine on-premise/Azure there don't exists object type "VECTOR" jet, it's just in planing/preview.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
CREATE VECTOR INDEX idx_OpenAIEmbedding
ON dbo.table_name (OpenAIEmbedding)
WITH (
VECTOR_DIMENSION = 1536, -- Assuming OpenAI embedding dimension
SIMILARITY_FUNCTION = 'COSINE'
);
Started executing query at Line 1
Msg 343, Level 15, State 2, Line 1
Unknown object type 'VECTOR' used in a CREATE, DROP, or ALTER statement.
Msg 155, Level 15, State 1, Line 4
'VECTOR_DIMENSION' is not a recognized CREATE VECTOR INDEX option.
Msg 153, Level 15, State 1, Line 4
Invalid usage of the option VECTOR_DIMENSION in the INDEX statement.
Total execution time: 00:00:00.664
Unknown object type 'VECTOR'
As the message says, for SQL Database Engine on-premise/Azure there don't exists object type "VECTOR" jet, it's just in planing/preview.