Category	Name	Description	Example
CREATE TABLE <table-name> ( )		CREATE TABLE tableName ( id serial PRIMARY KEY, name varchar(50) UNIQUE NOT NULL, dateCreated timestamp DEFAULT current_timestamp )
CREATE TABLE <table-name> as <select>
CREATE VIEW view_name AS SELECT column_name(s) FROM table_name WHERE condition
CREATE INDEX index_name ON table_name (column_name)
CREATE UNIQUE INDEX index_name ON table_name (column_name)
CREATE DATABASE database_name
CREATE PROCEDURE nameprocedure (input_parameter_name datatype, ... ) AS /* SQL code */ GO