Removing Objects

• Database

  • DROP DATABASE db_name
  • deletes ALL tables and data within it!!

• Table

  • DROP TABLE table_name
  • deletes table and its contents

• Index

  • DROP INDEX table_name.index_name
  • deletes named index on named table

Previous slide

Next slide

Back to first slide

View graphic version