Removes the keyspace.
DROP KEYSPACE <name>;
A DROP KEYSPACE statement results in the immediate, irreversible removal of a keyspace, including all column families and data contained in the keyspace.
DROP KEYSPACE MyTwitterClone;