Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2012

    Unanswered: Issues in dropping the schema

    Hi all,

    In our setup db2V9.7 with fixpack 4

    With the partitioned database, under the db having schema with the name of db2TT it contains morethan 300 tables.

    Need to drop the schema without dropping the tables,(but tables also not use)

    If any command is there to drop the schema? with the single query.

    I tried with db2 drop schema db2TT Restrict

    But it's not working.

    How to drop the schema?


  2. #2
    Join Date
    Apr 2006
    Provided Answers: 11
    you can not drop the schema if tables exists
    what is the purpose of this ?
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts