victorabraham
3/29/2020 - 5:59 AM

Reference SQL 2

--Data Definition langage(DDL) Examples
CREATE DATABASE myDB;
CREATE TABLE Orders (OrderId INT PRIMARY KEY, OrderDate DATE NOT NULL);
ALTER TABLE Orders ADD Customer VARCHAR(10);
DROP myDb;

--Data Control Language(DCL)
GRANT SELECT ON Customers To Accounting -- grants view permission to accounting
GRANT ALL ON Customers To Admins -- grants all permissions to admins
REVOKE ALL ON Orders FROM PUBLIC;