2 Replies Latest reply on Jan 11, 2016 3:58 PM by Kyle {unique}

    Deleting Tables

    87ef26f8-3229-4fa5-8953-df528e2f8720

      Hi, I am new to Oracle SQL Developer.

       

      I ran a script that created a table:

       

      CREATE TABLE Customer

      (CustNo VARCHAR2(8) CONSTRAINT CustNoNotNull NOT NULL,

      CustName VARCHAR2(30) CONSTRAINT CustNameNotNull NOT NULL,

      Address VARCHAR2(50) CONSTRAINT AddressNotNull NOT NULL,

      Internal CHAR(1) CONSTRAINT InternalNotNull NOT NULL,

      Contact VARCHAR2(35) CONSTRAINT ContractNotNull NOT NULL,

      Phone VARCHAR2(11) CONSTRAINT CPhoneNotNull NOT NULL,

      City VARCHAR2(30) CONSTRAINT CityNotNull NOT NULL,

      State VARCHAR2(2) CONSTRAINT StateNotNull NOT NULL,

      Zip VARCHAR2(10) CONSTRAINT zipNotNull NOT NULL,

          CONSTRAINT PK_CUSTOMER PRIMARY KEY (CustNo) ) ;


      In the Table section under your connections, these Customer table will appear after I run the script.


      How can I delete this table? I selected it and pressed delete on the keyboard but it won't go away.