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

/* -------------------------------------------------------------------- 
** NAME         SYBVUDRP.SQL - SQL script to drop all Oracle data        
**              dictionary views from Sybase System 10  database.                
**                                                                      
** MODIFIED  
**   kmuniasa    6/3/95  - Modified for Sybase System 10                                                          
**   ctchan      9/21/94 - Added SPOOL SQSDROP.LOG
**   ctchan      9/08/94 - Added USER_SYNONYMS		
**   ctchan      9/08/94 - Added PRODUCT_USER_PROFILE	
** -------------------------------------------------------------------- */

/*
** To use, you must use UBT.EXE as follows:
**
**  ubt.exe scott/tiger@odbc:sybsys10 @sybvudrp.sql qa
** 
** where scott is the user, tiger the password, sybsys10 the odbc datasource, 
** sybvudrp.sql the sql script, and qa the database name.
**
**
** DROPS ALL ORACLE DATA DICTIONARY VIEWS
*/

SPOOL SYBVUDRP.LOG

USE &1;


DROP INDEX S2ODTMAP.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;
DROP TABLE ROLE_SYS_PRIVS;
DROP TABLE USER_SYS_PRIVS;

SPOOL OFF
