| /* |
| * 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; |