sql class

INT

TEXT

BOOLEAN

STRING

UPDATE

INSERT

DELETE

SELECT

By using the ALTER TABLE command with RENAME

By deleting and recreating the table

By using the UPDATE command

By using the INSERT INTO command

To uniquely identify each row in a table

To enforce referential integrity between tables

To store large amounts of data

To speed up queries

FOREIGN KEY(SCHOOL_ID) REFERENCES SCHOOL(SCHOOL_ID)

PRIMARY KEY(SCHOOL_ID) REFERENCES SCHOOL(SCHOOL_ID)

ALTER TABLE SCHOOL ADD FOREIGN KEY(SCHOOL_ID)

CREATE FOREIGN KEY SCHOOL_ID REFERENCES SCHOOL

SELECT

QUERY

FIND

SEARCH

SELECT Name FROM Department

SHOW Name FROM Department

GET Name FROM Department

SELECT Department FROM Name

SELECT Name FROM Department WHERE Size = 'big'

SELECT Size FROM Department WHERE Name = 'big'

SELECT Name FROM Department WHERE Size = 'small'

SELECT Department FROM Name WHERE Size = 'big'