-
Notifications
You must be signed in to change notification settings - Fork 5
SchemaOnly
Jacek edited this page Feb 26, 2023
·
5 revisions
Some databases don't manage SchemaOnly
behavior properly:
- MySQL, PostgreSQL and Oracle performs well only for queries that return some results - commands not returning any are executed as with
Default
behavior
To overcome it, a special configuration flag has beed added (MakeDiagnosticCalls
) that controllsSchemaOnly
executions for commands without results and is by default set to false for mentioned databases - MS SQL doesn't recognize temporary tables in
SchemaOnly
executions, although, you can use table variables instead