--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;