To drop a table:

DROP TABLE <table-name>;

To specifically drop the cats table:

DROP TABLE cats;