1.CREATE SCHEMA company AUTHORIZATION LI
2.CREATE TABLE dept
(deptno CHAR(9) PRIMARY KEY,
dname CHAR(20) NOT NULL,
loc CHAR(20),
);
3.CREATE TABLE emp
(empno CHAR(9) PRIMARY KEY,
ename CHAR(20) NOT NULL,
hiredate CHAR(12),
job CHAR(20),
sal CHAR(12),
depton CHAR(9),
sex CHAR(2),
mgr CHAR(2),
FOREIGN KEY(deptno)REFERENCES dept(deptno)
);
4.ALTER TABLE emp ADD birthday DATE;
ALTER TABLE emp ALTER CHAR(2) sex CHAR(4);
5.
CREATE CLUSTER INDEX dname ON dept(d-index);
6.
可以
DROP SCHEMA company CASCADE;
7.
DROP INDEX d_index;
8.
DROP TABLE emp CASCADE;
9.
不可以,因为已经定义了下属的数据库对象dept,emp。