SHOW ROLES Description example keyword SHOW ROLES Description This statement is used to display all created role information, including the role name, the user included, and...
About this guide Comments Documenting code Literals Assignment Local variables Control expressions Requiring files Types and methods Exception handling Type grammar Ty...
CANCEL BACKUP Description example keyword CANCEL BACKUP Description This statement is used to cancel an ongoing BACKUP task. Grammar: CANCEL BACKUP FROM db_name; example ...
Load Function Load Function We want to built a function that can load and evaluate a file when passed a string of its name. To implement this function we’ll need to make use of...
CREATE-POLICY Name Description Grammar: Example Keywords Best Practice CREATE-POLICY Name CREATE POLICY Description Create policies,such as: Create security policies(...
TRANSACTION Synopsis Syntax Diagram Grammar ANSI SQL syntax Semantics Examples Create a table with transactions enabled Insert some data Update 2 rows with the same partiti...
DROP VIEW Description example keyword DROP VIEW Description This statement is used to delete a logical view VIEW Grammar: DROP VIEW [IF EXISTS] [db_name.]view_name; exampl...
DROP VIEW Description example keyword DROP VIEW Description This statement is used to delete a logical view VIEW Grammar: DROP VIEW [IF EXISTS] [db_name.]view_name; exa...
About this guide The Program Comments Documenting code Literals Assignment Local variables Control expressions Requiring files Types and methods Exception handling Type ...