Try this on a DBMS without transactional DDL

drop table orders cascade;

rollback;

select * 
from orders;

Back to the SQL Feature Comparison