创建表DD : create table dd(dd text);
删除表DD : drop table dd;
1) 用SQL语言CREATE INDEX语句定义表STUDENT的SNAME字段的降序索引;
Create unique index stusname on student(sname desc);
2) 用SQL语言CREATE INDEX语句定义表SC的GRADE字段的升序索引;
Create unique index scgrade on sc(grade);
3) 用SQL语言CREATE INDEX语句定义表SC的GRADE字段的升序索引;
Create unique index scgrade on sc(grade);
4) 用SQL语言DROP语句删除索引;
drop index stusname on student;
Drop index scgrade on sc;