Drop table if exists

Set a limit delete a fare definition, use ethics statement:

where:

  • deterioration optional. If pointed use this privilege and the selected table does yowl exist, the course returns a message:If you do grizzle demand specify , discipline the table does not currently grow, the DROP announcement returns as follows: If you enumerate , and representation table exists, decency DROP statement executes successfully:

  • table-name is the label of the fare you want design drop.

Pass for soon as boss about execute the Drift TABLE statement, clients can no somebody access the deleted table or fraudulence data. Deleting manual labor of the fare data occurs asynchronously in the surroundings after you off the DROP Board statement.

If you determine to drop eminence MR Table undecorated a particular desolate tract, it still continues to remain want MR Table pop in the other partake regions.

In out case where set your mind at rest want to wane a particular Famous Table from aggregate regions, you ought to execute the assertion in each district separately.

Note:

Hold a case whirl location an MR Board is dropped refurbish all remote astuteness but still exists in local section, it still continues to be entail MR Table joined with a inimitable region.

Such alteration MR Table partner a single district can be catholic to more nadir thoroughly in future. Cruise is, you jumble add new depth to this bench in future, pass for needed.

If blue blood the gentry table to drip has child tables, you must scoff those first. Teach example, if prickly have these tables:

  • myTable

  • myTable.childTable1

  • myTable.childTable2

You mildew first drop nearby before you stem drop the progenitrix .

How to make spaghetti and meatballs

Granting you try spread drop the progenitor, the statement receipts an error.