I'm not 100% sure, but I don't think there is any differenc in the syntax of DROP TABLE command for IOT as opposed to heap tables. PKs and indexes will be dropped automaticaly. But if you have FKs from other tables referencing your IOT you'll have to trop those foreign keys before dropping your IOT.
HTH,




Reply With Quote