CREATE TABLE Customer (Custno character(7), Name character(20), Credlim decimal(9.2), Phone character(10), );
CREATE TABLE MyOrders (Custno character(7), Amount Decimal(9.2)) AS SELECT .....;
ALTER TABLE Customer DELETE COLUMN Phone;
ALTER TABLE Customer ADD COLUMN Address character(24);
DROP TABLE Customer
CREATE INDEX CustIndx ON Customer (Custno,Phone);
DROP INDEX CustIndx;
CREATE VIEW Orders AS SELECT ......;

DCL
GRANT SELECT ON slsrep (Name,phone) TO Loring;
GRANT UPDATE ON parts (Cost, NumPurchased, NumSold) TO Newell;
GRANT DELETE ON customer TO JH24478;
GRANT INSERT ON orders TO entryClerk;
GRANT ALTER ON customer TO TX343;
GRANT ALL ON slsrep, customer, orders, TO Schoch;
REVOKE SELECT ON slsrep(commission) TO Loring;
REVOKE SELECT ON slsrep TO Loring;

DML
Projection
SELECT tpNum, Name FROM tape;
Selection and projection
SELECT tpNum, name FROM tape WHERE TimeRented : 10;
Selection, projection, join
SELECT c.cusname, c.phone, r.amount FROM customer c, receivable r, WHERE r.age:30 AND r.amount:c.credlim AND r.cusno=c.cusno;

Original file name: sqlLecture

This file was converted with TextToHTML - (c) Logic n.v.