Top "Sql-drop" questions

`DROP` is a keyword in sql.

How to remove all MySQL tables from the command-line without DROP database permissions?

How do I drop all tables in Windows MySQL, using command prompt? The reason I want to do this is …

mysql command-line sql-drop
Oracle: If Table Exists

I'm writing some migration scripts for an Oracle database, and was hoping Oracle had something similar to MySQL's IF EXISTS …

sql oracle sql-drop
MySQL DROP all tables, ignoring foreign keys

Is there a nice easy way to drop all tables from a MySQL database, ignoring any foreign key constraints that …

mysql foreign-keys innodb sql-drop
How to drop all user tables?

How can I drop all user tables in oracle? I have problem with constraints. When I disable all it is …

oracle constraints sql-drop
How to drop unique in MySQL?

Create Table: CREATE TABLE `fuinfo` ( `fid` int(10) unsigned NOT NULL, `name` varchar(40) NOT NULL, `email` varchar(128) NOT NULL, UNIQUE KEY `…

mysql indexing sql-drop
Force drop mysql bypassing foreign key constraint

I'm trying to delete all tables from a database except one, and I end up having the following error: Cannot …

mysql foreign-keys sql-drop
How do I drop a column with object dependencies in SQL Server 2008?

The error message I'm obtaining when trying to drop a column: The object 'defEmptyString' is dependent on column 'fkKeywordRolleKontakt'. Msg 5074, …

sql sql-server sql-server-2008 dependencies sql-drop
SQL: deleting tables with prefix

How to delete my tables who all have the prefix myprefix_? Note: need to execute it in phpMyAdmin

mysql phpmyadmin sql-drop
What is the syntax to drop a Stored Procedure in SQL Server 2000?

Simple question, as the title suggests: What is the syntax to drop a Stored Procedure (SP) in SQL Server 2000, by …

stored-procedures sql-server-2000 sql-drop
ERROR 1396 (HY000): Operation DROP USER failed for 'user'@'localhost'

I have created a user in mysql. Now i want to delete the user ? How to do that? I am …

mysql amazon-web-services sql-drop