164 questions
0
votes
1
answer
558
views
CockroachDB: The best way to turn a UNIQUE CONSTRAINT into a PRIMARY KEY?
We have tables in CockroachDB which have a PK which always have 2 extra columns prefix, e.g. (u1, u2, id), now not needed anymore.
For performance, there's also the real primary key set up as a UNIQUE ...
- 47.2k
1
vote
1
answer
335
views
Drop and recreate a table with data of a Graph DB
This is a follow up question to this question:
SQL drop table and re-create and keep data
I got a table in a Graph db (inside SQL Server) for which I need to change one of its columns' name and type. ...
- 12.6k
0
votes
1
answer
786
views
How Drop the only subpartition of a partition
While I am deleting subpartitions, one of the partition contains only one subpartition I got an error.
Error: ORA-14629 cannot drop the only subpartition of a partition
Can anyone know how to drop ...
- 45
1
vote
1
answer
6k
views
Drop all partitions from a table MySQL
How can I drop all partitions from a table in MySQL. I know you can drop specific partitions with ALTER TABLE table_name DROP PARTITION p0, p1, but is there a way to not list every single partition ...
- 366
0
votes
1
answer
215
views
MySQL : error 1217 on DROP TABLE. Foreign key refering on its own primary key. ON DELETE CASCADE is on
I'm trying this query
DROP TABLE IF EXISTS Core;
on a table created with this query
CREATE TABLE Core (
id serial PRIMARY KEY,
title varchar(512),
kind ENUM('User', 'Organisation', '...
- 5
0
votes
2
answers
118
views
How to drop an in-memory table in dolphindb?
In dolphindb,I can create an in-memory table in dolphindb like:
t = table(1 2 3 as id);
And I can use sql statements at it.
But I don't know the right way to delete it.The function
dropTable(dbHandle,...
- 33
1
vote
2
answers
4k
views
Unable to drop database in Postgres
I'm new to databases in general and Postgres in particular.
I'm doing something wrong as I'm unable to drop a database.
I've searched for similar issues, but it's always someone that has lost or does ...
- 322
1
vote
1
answer
698
views
How do you measure the impact of dropping a schema in Oracle?
I have a aged and redundant schema that I want to drop. Running DROP USER old_schema CASCADE runs succesfully and it's dropped.
How can I find out whether dropping this schema results in other ...
- 128
1
vote
0
answers
3k
views
Does dropping a table drop its dependent trigger? [duplicate]
Dropping a table invalidates dependent objects and removes object
privileges on the table. If you want to re-create the table, then you
must regrant object privileges on the table, re-create the ...
- 783
-1
votes
3
answers
527
views
Drop behavior in SQL DROP VIEW statement
Is the Statement:
DROP VIEW <view-name>
a valid sql92 syntax? In some Databases (e.g Postgres, Redshift) there is the option to explicitly define a drop behavior
DROP VIEW <view-name> [...
- 1,250
2
votes
2
answers
3k
views
Cannot drop trigger getting error in PostgreSQL
I am learning PostgreSQL after python. I follow tutorialspoint.com website.
There is no problem until i create a trigger and it works like a charm..
But when I tried to delete (i.e., drop) the ...
- 377
0
votes
1
answer
74
views
Strange result when dropping table in SQL
When I drop the table in SQL I get a strange result. My table was not dropped but shows:
BIN$0X1RWoaWQlSLcefLZbH5jA==$0 TABLE
What is this?
How can I delete the table?
- 1
1
vote
1
answer
2k
views
How do I dynamically DROP stored procedures and functions using prepared statements (MySQL) -- DROP PROCEDURE LIKE
I've been trying to dynamically drop tables, procedures, and functions in MySQL. I'm doing this because I am dynamically creating them for a project, when the project version changes I need to clean ...
- 638
91
votes
5
answers
173k
views
Cannot drop table users because other objects depend on it
I want to drop my tables in my database.
But, when I use, for example,
DROP TABLE if exists users;
I receive this message:
cannot drop table users because other objects depend on it
I found the ...
- 27.3k
0
votes
3
answers
2k
views
Delete all objects in schema using batch file in Oracle
I have below Select query which will generate delete statements to delete all objects in schema.
select 'DROP '||OBJECT_TYPE||' '||OWNER||'.'||OBJECT_NAME
|| case when OBJECT_TYPE = 'TABLE'
...
- 4,021