SchemaOnly

Jump to bottom

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 controlls SchemaOnly 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