Procuremos más ser padres de nuestro porvenir que hijos de nuestro pasado.
Miguel de Unamuno

Drop all tables from an schema in Oracle

I’ve found a nice solution for dropping all the tables from an existing schema in Oracle, described in this question at stackoverflow. The following script :

SELECT 'drop table '||TABLE_NAME||' cascade constraints;' FROM user_tables;

will display the sentences required for dropping all the tables in the current schema.

2 Comentarios hasta el momento »

  1. how to configure best best comcast best modem for xbox live dijo

    6 de June del 2016 a las 10:15 am

    how to configure best best comcast best modem for xbox live…

    Drop all tables from an schema in Oracle | Lycka Bonita…

  2. how to configure best best buy cable modem for comcast dijo

    8 de June del 2016 a las 8:49 pm

    how to configure best best buy cable modem for comcast…

    Drop all tables from an schema in Oracle | Lycka Bonita…

Comentarios RSS · TrackBack URI

Dejanos tu Comentario

Nombre: (Requerido)

E-Mail: (Requerido)

Sitio WEB:

Comentario:

Comenta