Alright it worked for blah: cursor.execute("DROP SEQUENCE BLAH_SEQUENCE")
Going for the rest now. On Monday, December 28, 2015 at 10:09:31 AM UTC-8, Michael Messmer wrote: > > Ahh, I am ULTRA-Newb to db's: > > here is what it returned: > > >>> for row in cursor: > ... print row > ... > ('SYS_C0012098', 'INDEX') > ('SYS_LOB0000092306C00003$$', 'LOB') > ('AUTH_CAS_SEQUENCE', 'SEQUENCE') > ('AUTH_EVENT_SEQUENCE', 'SEQUENCE') > ('AUTH_GROUP_SEQUENCE', 'SEQUENCE') > ('AUTH_MEMBERSHIP_SEQUENCE', 'SEQUENCE') > ('AUTH_PERMISSION_SEQUENCE', 'SEQUENCE') > ('AUTH_USER_SEQUENCE', 'SEQUENCE') > ('BLAH_SEQUENCE', 'SEQUENCE') > ('AUTH_USER', 'TABLE') > > > I just googled dropping Objects. Wish me luck. ill report back. > > > On Monday, December 28, 2015 at 9:59:18 AM UTC-8, Dan Feeney wrote: >> >> You can view tables owned by the current user with: >> >> SELECT TABLE_NAME FROM USER_TABLES ORDER BY TABLE_NAME; >> >> >> >> You can view all objects owned by the current user with: >> >> SELECT OBJECT_NAME, OBJECT_TYPE FROM USER_OBJECTS ORDER BY 2, 1; >> >> >> >> HTH, >> -Dan >> > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.