/* $Id: rdbvudrp.sql,v 1.1 1998/03/26 22:00:40 yxia Exp $		*/
/* $Log: rdbvudrp.sql,v $
# Revision 1.1  1998/03/26  22:00:40  yxia
# Initial revision
#
# Revision 1.1  1997/09/03  21:53:31  bgutierr
# Initial revision
#
# Revision 1.4  1997/07/09  23:42:04  aclarke
# log: OCA 2.0.2.11.0 files.
#
# Revision 1.1  1996/02/06  18:06:00  kmuniasa
# log: Initial version for d2 1.3 release.
#	*/
/* Copyright (c) 1993, 1994 by the Oracle Corporation */

/* -------------------------------------------------------------------- 
** NAME         RDBVUDRP.SQL - SQL script to drop all Oracle data        
**              dictionary views on Rdb database.                
**                                                                      
** MODIFIED  
**   kmuniasa	 1/27/95 - Modified for RDB                                                           
**   ctchan      9/21/94 - Added SPOOL SQSDROP.LOG
**   ctchan      9/08/94 - Added USER_SYNONYMS		
**   ctchan      9/08/94 - Added PROCUT_USER_PROFILE	
** -------------------------------------------------------------------- */

/*
** To use, you must use UBT.EXE as follows:
**
** like: ubt.exe scott/tiger@odbc:dbname @rdbvudrp.sql 
** 
** where scott is the user, tiger the password, dbname the  odbc datasource, 
** and rdbvudrp.sql the sql script to run.
**
**
** DROPS ALL ORACLE DATA DICTIONARY VIEWS
*/

SPOOL RDBVUDRP.LOG


DROP INDEX IS2ODTMAP;
DROP TABLE S2ODTMAP;
DROP TABLE ALL_SYNONYMS;
DROP TABLE USER_SYNONYMS;
DROP TABLE PRODUCT_USER_PROFILE;
DROP VIEW ALL_USERS;
DROP VIEW ALL_OBJECTS;
DROP VIEW ALL_TABLES;
DROP VIEW ALL_VIEWS;
DROP VIEW ALL_TAB_COLUMNS;
DROP VIEW USER_USERS;
DROP VIEW ACCESSIBLE_COLUMNS;
DROP TABLE TOOL_MODULE;
DROP TABLE ALL_TRIGGERS;
commit;
SPOOL OFF
