SQL Statements › SQL Overview › Other Acceptable SQL Keywords

Other Acceptable SQL Keywords

Additional SQL keywords can also be submitted with CA Dataquery. You must have special authorization from your CA Dataquery Administrator to use these keywords in CA Dataquery.

Data definition authorization allows you to use:

• ALTER
• CREATE INDEX
• CREATE SYNONYM
• CREATE TABLE
• CREATE VIEW
• COMMENT ON
• DROP
• GRANT
• REVOKE

Data maintenance authorization allows you to use:

• DELETE
• INSERT
• UPDATE

Some information about using these keywords in CA Dataquery can be found in the CA Dataquery Administrator Guide. Also, see the CA Dataquery User Guide to compare DQL and SQL Query usage.