Create Table
CREATE TABLE PRESENTERS
(PRESENTERID CHAR (6) PRIMARY KEY NOT NULL, PNRLNAME VARCHAR (20) NOT NULL, PNRFNAME VARCHAR (20) NOT NULL,
GENDER CHAR (2) DEFAULT ‘M’, AGE SMALLINT NOT NULL CHECK (AGE>=18), YEARS SMALLINT NOT NULL, SALARY_YEARLY DECIMAL (10, 2) NOT NULL);

CREATE TABLE EPISODES (EPISODENO INT IDENTITY (1,1) PRIMARY KEY NOT NULL, EPISODENAME VARCHAR (50) NOT NULL, DATEAIRED DATE NOT NULL, GUEST VARCHAR (50), COUNTRYAIRED VARCHAR (10) NOT NULL, PRESENTERID CHAR (6) FOREIGN KEY REFERENCES PRESENTERS (PRESENTERID), CARNO CHAR (7) FOREIGN KEY REFERENCES CARS (CARNO));

Insert Into Table
INSERT INTO PRESENTERS
(PRESENTERID, PNRLNAME, PNRFNAME, AGE, YEARS, SALARY_YEARLY)
VALUES
('EMP_01','NEEDELL','TIFF', 61, 10, 374500.70),
('EMP_02','BUTLER-HENDERSON','VICKI', 41, 10, 24262.55),
('EMP_03','PLATO','JASON', 45, 8, 29100.98);

Alter Tables Add Column
ALTER TABLE EMPLOYEES
ADD LAST_NAME VARCHAR (50) Datatypes
ALTER TABLE CAKES
ALTER COLUMN CAKENO CHAR (8) NOT NULL
Constraints
ALTER TABLE EMPLOYEES
ADD CONSTRAINT PK1 PRIMARY KEY (EMPID)
Foreign Keys ALTER TABLE EPISODES
ADD FOREIGN KEY (CAKENO) REFERENCES CAKES (CAKENO)
Change Column
SP_RENAME 'TABLE_NAME'.'OLD_COLUMN_NAME', 'NEW_COLUMN_NAME', 'COLUMN';
Drop Column
ALTER TABLE EMPLOYEES
DROP COLUMN LAST_NAME;

Delete Row
DELETE FROM CARS
WHERE CARMAKE='SUBARU WRX'

Drop Table
DROP TABLE EMPLOYEES

Update Tables
UPDATE PRESENTERS
SET SALARY_YEARLY = SALARY_YEARLY+1000000
WHERE PNRLNAME='CLARKSON' RULES CREATE RULE CREATE RULE SALARY RULE
AS @SALARY >0;
DROP RULE
DROP RULE SALARYRULE
DROP DEFUALT
DROP DEFAULT GENDER
DROP CONSTRAINT
ALTER TABLE EMPLOYEES
DROP CONSTRAINT EMPLOYEES_PK;

ALTER TABLE EMPLOYEES
DROP PRIMARY KEY;

ALTER TABLE EMPLOYEES
ALTER COLUMN SALARY DROP DEFAULT;

Queries
SELECT *