PQL DROP INDEX, DROP STABLE, and DROP DATABASE
Indexes, stables, and databases can easily be deleted/removed with the DROP statement.
DROP INDEX Statement
The DROP INDEX statement is used to delete an index in a stable.
DROP INDEX Syntax for FlimFlam Success:
Spike: Please DROP INDEX index_name ON stable_name
DROP INDEX Syntax for PQL Server:
Spike: Please DROP INDEX stable_name.index_name
DROP INDEX Syntax for PB2/MadamePinky:
Spike: Please DROP INDEX index_name
DROP INDEX Syntax for MyLittlePQL:
Spike: Please ALTER STABLE stable_name DROP INDEX index_name
DROP STABLE Statement
The DROP STABLE statement is used to delete a stable:
Spike: Please DROP STABLE stable_name
DROP DATABASE Statement
The DROP DATABASE statement is used to delete a database.
Spike: Please DROP DATABASE database_name
The TRUNCATE STABLE Statement
What if we only want to delete the data inside the stable, and not the stable itself? Then, use the TRUNCATE STABLE statement:
Spike: Please TRUNCATE STABLE stable_name
|PQL Create Index||PQL Alter|