SQL: Significant supported features

• Privileges
• SELECT, INSERT, UPDATE, DELETE, REFERENCES at table level
• Trigger privileges


• Data integrity constraints
• NOT NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY, CHECK, defaults


• Transactions
  • BEGIN, COMMIT, ROLLBACK
  • SET TRANSACTION ISOLATION LEVEL SERIALIZABLE, READ COMMITTED
  
  
• Triggers
  • UPDATE, INSERT, DELETE
  • BEFORE, AFTER, FOR EACH ROW
  
  
• Comments
• --
• /* ... */

Page 24