- It is a standard for relational databases
- It has statements for data definitions, queries and updates (DDL and DML)
- Facilities for defining views
- Specify transaction controls
- Data Validation – Check that people are entering correct input, e.g. to make sure an employee is not being over paid, you could use CHECK (Salary < 150000.00) to make sure they do not get more than 150,000 a year (in your dreams)
- Levels of access; user privileges (DCL) – GRANT; grant privileges to certain users. Can also revoke privileges with REVOKE.
Comments
No comments have yet been made