DB2 - L

 View Only
  • 1.  Drop on Restrict

    Posted Apr 20, 2022 01:23 PM
    Hi Team,

    We have one table which has Drop on Restrict clause on it.

    What is the command to drop that restriction.

    Thank in advance
    Sekhar.

    ------------------------------
    Sekhar
    ------------------------------


  • 2.  RE: Drop on Restrict

    Posted Apr 20, 2022 01:25 PM

    ALTER TABLE              

      Tbcreator.tbname         

        DROP RESTRICT ON DROP

    ;                        

     






  • 3.  RE: Drop on Restrict

    Posted Apr 20, 2022 01:30 PM
    Thanks it worked


    Sekhar.

    ------------------------------
    Sekhar
    ------------------------------