dcsimg
LinkedIn
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


advertisement
 

Oracle Database Tip: Dropping Tables without Errors

In this quick Oracle database tutorial, you will learn how to drop tables from a database without receiving any errors.


advertisement

Sometimes when you drop tables in an Oracle database you will get errors. This is how you drop tables in Oracle without getting errors:

BEGIN
   EXECUTE IMMEDIATE 'DROP TABLE "TABLE_FOO" CASCADE CONSTRAINTS';
EXCEPTION
   WHEN OTHERS THEN NULL;
END;
/


   
Email AuthorEmail Author
Close Icon
Thanks for your registration, follow us on our social networks to keep up-to-date