DROP TABLE IF EXISTS SNOMEDCORE(version); CREATE TABLE SNOMEDCORE(version) ( SNOMED_CID VARCHAR(20) NOT NULL, SNOMED_FSN VARCHAR(500) NOT NULL, SNOMED_CONCEPT_STATUS VARCHAR (30) NOT NULL, UMLS_CUI VARCHAR (10) NOT NULL, OCCURRENCE NUMBER, USAGE NUMBER, FIRST_IN_SUBSET VARCHAR (20) NOT NULL, IS_RETIRED_FROM_SUBSET VARCHAR (10) NOT NULL, LAST_IN_SUBSET VARCHAR (20), REPLACED_BY_SNOMED_CID VARCHAR (20) ) ;