Top "Sql-drop" questions

What happens to index once the table got dropped?

After dropping the table, found that the index created on the columns of the dropped table is gone. I just …

sql indexing sql-drop

DB2 Drop table if exists equivalent

I need to drop a DB2 table if it exists, or drop and ignore errors.

sql db2 sql-drop

Cannot create a new table after "DROP SCHEMA public"

Since I wanted to drop some tables and somebody suggested the below and I did it: postgres=# drop schema public …

database postgresql database-schema create-table sql-drop

PostgreSQL drop role fails because of default privileges

I am trying to drop a role 'xyz' that was previously the owner of the schema with the same name …

postgresql sql-drop

How to reuse the Unused columns again in oracle DB

I have a table with 4 column, ID, NAME,AGE and COUNTRY. For some time being purpose i have set my …

oracle10g sql-drop

DROP FUNCTION without knowing the number/type of parameters?

I keep all my functions in a text file with 'CREATE OR REPLACE FUNCTION somefunction'. So if I add or …

postgresql plpgsql dynamic-sql sql-drop

Does dropping a table in MySQL also drop the indexes?

It's not explicitly mentioned in the documentation (http://dev.mysql.com/doc/refman/6.0/en/drop-table.html). I ask because I …

mysql database indexing sql-drop

How to DROP a database with character '?' in its name?

Just trying out ubuntu server on my pc and have been testing some commands including mysql. I'm not sure why …

mysql database sql-drop

MySQL drop table

I want to drop a table with drop table EMPLOYEE; but I get the error: #1217 - Cannot delete or update …

mysql foreign-keys sql-drop

How to drop all tables in db2

I want to drop all tables in db2 database with foregin keys, without drop and recreating.

sql db2 sql-drop