dotnet / dotnet/SqlClient

GetSchema("DataTypes") does not return entries for JSON and VECTOR types

Open
#3,833 3 comments 0 reactions 1 assignee Claimed by @apoorvdeshmukh View on GitHub
Dominant language
C#
Stars
989
Forks
340
Avg merge
4d 19h
Merged PRs (30d)
72

Description

### Describe the bug

`SqlConnection.GetSchema("DataTypes")` does not include rows for the built-in SQL Server types **JSON** and **VECTOR**.

### To reproduce

```c#
using Microsoft.Data.SqlClient;

using var connection = new SqlConnection("Server=.;Database=master;Integrated Security=true;");
connection.Open();

var table = connection.GetSchema("DataTypes");

bool hasJson = table.Rows.Cast().Any(r => ((string)r["TypeName"]).Equals("json", StringComparison.OrdinalIgnoreCase));
bool hasVector = table.Rows.Cast().Any(r => ((string)r["TypeName"]).Equals("vector", StringComparison.OrdinalIgnoreCase));

Console.WriteLine($"JSON found: {hasJson}");
Console.WriteLine($"VECTOR found: {hasVector}");
```

**Actual**: both return `false`
**Expected**: both types should be included

### Further technical details
Microsoft.Data.SqlClient version: all versions, including prerelease
.NET target: all
SQL Server version: SQL Server 2025
Operating system: any

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.