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

    Deleting Tables


      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,


      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.