FANDOM



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

Ad blocker interference detected!


Wikia is a free-to-use site that makes money from advertising. We have a modified experience for viewers using ad blockers

Wikia is not accessible if you’ve made further modifications. Remove the custom ad blocker rule(s) and the page will load as expected.