asterix-app/src/test/resources/metadata/queries/basic/meta12.aql

/*
 * Description  : Create secondary index and drop the secondary index and query metadata to verify drop index.
 * Expected Res : Success 
 * Date         : Sep 17 2012
 */

drop dataverse test if exists;
create dataverse test;

write output to nc1:"mdtest/basic_meta12.adm";

create type test.testtype as open {
id : int32,
name : string
}

create dataset test.dst01(testtype) partitioned by key id;

create index idx1 on test.dst01(name);

drop index test.dst01.idx1;

for $l in dataset('Metadata.Index')
where $l.DatasetName = 'dst01'
return $l

drop dataverse test;