/* Copyright (c) 1997 by the Oracle Corporation */

/* ----------------------------------------------------------------- 
** NAME         INGVUDRP.SQL - SQL script to drop all Oracle-style
**              data dictionary views on an Ingres database (undoes 
**              the work of ingvubld.sql).              
**                                                                      
** ------------------------------------------------------------------
**
** To run this script, please use SQL*Plus with syntax similar to :-
**
** plus33w.exe scott/tiger@odbc:ING64 @ingvudrp.sql 
** 
** where scott is the user name, tiger the password, ING64 the ODBC
** datasource, ingvudrp.sql the sql script.
**
*/

SPOOL INGVUDRP.LOG

drop view ALL_TRIGGERS; 
drop view TOOL_MODULE;
drop view USER_SYS_PRIVS;
drop view ROLE_SYS_PRIVS;
drop view PRODUCT_USER_PROFILE;
drop view USER_SYNONYMS;
drop view ALL_SYNONYMS;
drop view ACCESSIBLE_COLUMNS;
drop view ALL_TAB_COLUMNS;
drop view ALL_VIEWS;
drop view ALL_TABLES;
drop view ALL_ERRORS;
drop view ALL_SOURCE;
drop view ALL_OBJECTS;
drop view USER_USERS;
drop view ALL_USERS;
drop table d2k_object_types;
drop table d2k_empty_table;
drop table d2k_dtmap;

commit;

SPOOL OFF

