Hi everyone i tried closing the sql editor and also it didnt work.Then I changed the table name to apmc_dc_ref_category which was earlier
apmc_dc_reference_category then it worked fine.Actually i think the problem was coming because the foreign key constraint statement was having
reference(apmc_dc_reference_category) keyword
(
CONSTRAINT fk_1_apme_dc_reference FOREIGN KEY (apme_dc_tag_unit_refno)
REFERENCES apmc_dc_reference_category (apmc_dc_reference_sno) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE NO ACTION)
)..
After i changed the tablename its coiming correctly...
Can anyone say how i can have the same tablename and still be able to create the table
thanks
regrds