csql7.sql

来自「b树实现源码,linux和unix下运行,速度快,极好用」· SQL 代码 · 共 9 行

echo Descr:drop index  test;
create table t1 (f1 integer not null, f2 integer not null, 
                 f3 int not null, f4 int not null);
create index idx1 on t1 (f1);
create index idx2 on t1 (f2) UNIQUE;
create index idx3 on t1 (f3) PRIMARY;
drop index idx2;
drop table t1;