Progress
Embedded SQL-92
Guide and Reference


DROP VIEW

The DROP VIEW statement deletes an existing view from the database.

EXAMPLE

The following example drops the ne_customer view:

/* 
** CONNECT to the DEFAULT database. 
*/ 
EXEC SQL 
     CONNECT TO DEFAULT ;  
/* 
** Drop the ne_customer view. 
*/ 
EXEC SQL 
     DROP VIEW ne_customer ; 
if (sqlca.sqlcode < 0) 
{\n 
     printf ("DROP VIEW statement failed (%ld : %s) ", 
          sqlca.sqlcode, sqlca.sqlerrm);  
     EXEC SQL ROLLBACK WORK ;  
     EXEC SQL DISCONNECT DEFAULT ;  
     exit (1); 
} 
/*  
** Successful drop; commit the operation. 
*/ 
EXEC SQL 
     COMMIT WORK ;  
printf ("DROP VIEW ne_customer 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