Top "Sql-drop" questions

`DROP` is a keyword in sql.

ORACLE :Are grants removed when an object is dropped?

I currently have 2 schemas, A and B. B has a table, and A executes selects inserts and updates on it. …

oracle rename grant ora-00942 sql-drop
mysql drop table if exists inside procedure

I'm trying to apply a nested set model example with procedures. I've found many of them with this technique and …

mysql procedure sql-drop
how to drop a replicated table in both the publication and subscription

How do I drop a replicated table in the publication as well as the subscription? (scripts only) I do not …

tsql replication sql-drop
Unable to drop database due to illegal character

How can i drop a database containing the "-" symbol? mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | …

mysql sql-drop
Mysql "drop function if exists" fails with code 1305

When I try to execute the code bellow I get mysql error 1305: DROP FUNCTION IF EXISTS myFunction; It only fails …

mysql sql-drop
drop index or constraint without knowing its name for Oracle

On a oracle database I have a foreign key, without knowing its name, just the column_name and the reference_…

sql oracle constraints sql-drop
How to drop multiple tables having foreign keys in PostgreSQL?

I know syntax for deleting multiple tables is: DROP TABLE foo, bar, baz; But in my case 3 tables having foreign …

sql postgresql sql-drop
If foreign key exists, drop it

I have a table that has a foreign key relation with another table. I want to check that if this …

sql foreign-keys exists sql-drop
I dropped a table in Oracle, how can I retrieve it from the undo tablespace?

I accidentally dropped a fairly large table -- recycling bin is not enabled. I'm fairly certain the data still exists …

sql oracle undo flashback sql-drop