Query Syntax and SQL Grammar

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.