19
How the Programmer Sees the DBMS
•Start with DDL to create
tables:
•Continue with DML to populate
tables:
CREATE TABLE Students
(
Name CHAR(30)
SSN CHAR(9) PRIMARY KEY NOT NULL,
Category CHAR(20)
) . . .
INSERT INTO
Students
VALUES(‘Charles’,
‘123456789’, ‘undergraduate’)
. .
. .