WinSQL Professional does not contain its own syntax. It inherits the SQL dialect from the back-end server and submits the query “as is” to the back-end database. Similarly, it displays the results data “as is” from the server. This feature allows users to submit queries that are specific to a particular database.
There are, however, exceptions to this rule. The submitted script is modified under the following conditions.
·When you use a WinSQL Professional specific parameter in the query. In this case, the parameter will be replaced before submitting the query
·If a query terminator is found within the script. The default value for query terminator is ‘GO’.
·You use a code template. Code templates are explained in more detail in the “Database-Specific Plug-Ins” topic in this document. Templates replace pre-defined tokens into server specific SQL. For example, when a user types DESCRIBE <TABLENAME> in an Oracle database, WinSQL Professional replaces this command with a set of Oracle specific scripts necessary to pull table definition.