Progress
Embedded SQL-92
Guide and Reference


DROP INDEX

Use the DROP INDEX statement to drop an index on a table.

EXAMPLE

The following code fragment shows a DROP INDEX statement, dropping the idx_cust index on the customer table:

/* 
** CONNECT to the DEFAULT database. 
*/ 
EXEC SQL 
     CONNECT TO DEFAULT ;  
/* 
** DROP the idx_cust index.  
*/ 
EXEC SQL 
     DROP INDEX idx_cust ON customer;  
if (sqlca.sqlcode < 0) 
{ 
     printf ("DROP INDEX statement failed (%ld : %s) \n", 
             sqlca.sqlcode, sqlca.sqlerrm);  
     EXEC SQL ROLLBACK WORK ;  
     EXEC SQL DISCONNECT DEFAULT ;  
     exit (1); 
} 
/* 
** Successful drop; commit the drop index operation. 
*/ 
EXEC SQL COMMIT WORK ;  
printf ("DROP INDEX idx_cust successful.\n");  
/*  
** Disconnect from the default database. 
*/ 
EXEC SQL  
     DISCONNECT DEFAULT ; 


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095