title: Oracle SQL Developer : Error Unknown Command (CHECK)
body: <p>Can anyone tell me why my check code is giving me a error of 
  Error report:
  Unknown Command</p>
  
  <p>Below is my code for the table</p>
  
  <pre><code>PROMPT 'Creating Table property'
  CREATE TABLE tp_property
  (
      propertyid      NUMBER(20)   NOT NULL,
      landlordroleid      NUMBER(20)   NOT NULL,
      address         VARCHAR2(50) NOT NULL,
      city            VARCHAR2(15) NOT NULL,
      state           CHAR(2)      NOT NULL,
      zipcode         VARCHAR2(10) NOT NULL,
      county          VARCHAR2(20) NOT NULL,
      schooldistrict      VARCHAR2(50) NOT NULL,
      yearbuilt           CHAR(4)      NOT NULL,
      numberofbeds        CHAR(4)      NOT NULL,
      numberofbaths       CHAR(4)      NOT NULL,
      numberofrooms       CHAR(4)      NOT NULL,
      petsallowed         CHAR(1),
      onsiteparking           CHAR(1),     
      inunitlaundry           CHAR(1),     
      propertype      VARCHAR2(10) NOT NULL,
  CONSTRAINT tp_property_PK PRIMARY KEY ( propertyid ) ) ;
  
  ALTER TABLE tp_property
  ADD CONSTRAINT  tp_property_FK FOREIGN KEY (landlordroleid)
      REFERENCES  tp_landlordrole(landlordroleid);
  
  CONSTRAINT tp_property_CK CHECK (state IN ('NY', 'NJ', 'PA' ) ;
  
  PROMPT Creating Index 'tp_property_I'
  CREATE INDEX tp_property_I ON tp_property
   ( landlordroleid );
  
  PROMPT 'Creating Sequence tp_propertyid_seq for the tp_property table'
  CREATE SEQUENCE tp_propertyid_seq START WITH 0 MINVALUE 0 NOCACHE;
  </code></pre>
  
  <p>any suggestions are welcome thank you!</p>