Basic SQL
Basic SQL. CREATE/DROP/ALTER TABLE. Data types : char, varchar, decimal, date CREATE TABLE DEPARTMENT ( DNAME VARCHAR(10) NOT NULL, DNUMBER INTEGER NOT NULL, MGRSSN CHAR(9), MGRSTARTDATE CHAR(9) ); DROP TABLE DEPENDENT; ALTER TABLE : three options ADD, MODIFY,DROP a column
767 views • 59 slides