sys.external_models#
Lists the external generative AI models registered with
qua_add_external_ai_model —
the models the AI functions invoke. The view takes
its name from SQL Server 2025’s sys.external_models catalog view but exposes only the columns
relevant to Querona’s generative models; it is not a column-for-column clone (SQL Server’s view
also carries columns for the embeddings model type, which Querona does not implement).
The view is instance-scoped, consistent with how Querona scopes connections: the same list is visible from every database context. The model’s secret is never exposed by this view.
Column name |
Data type |
Description |
|---|---|---|
model_id |
int |
Identifier of the model registration. |
name |
sysname |
The model’s registration name. |
api_format |
sysname |
Provider wire format: |
location |
nvarchar(4000) |
The HTTPS endpoint requests are sent to. |
model |
sysname |
The provider-side model identifier. |
model_type |
sysname |
Always |
parameters |
nvarchar(4000) |
The optional provider request parameters (JSON), as registered. |
Example#
SELECT name, api_format, model FROM sys.external_models;