DROP SEQUENCE not working on MonetDB

Asked Dec 09 '15 at 18:16

Active Dec 09 '15 at 18:46

Viewed 96 times

Whenever I try to drop a sequence I get the following error:-

DROP SEQUENCE seq_12129;

DROP SEQUENCE: unable to drop sequence seq_12129 (there are database objects which depend on it)

I have dropped all the tables in the current schema, but I am still getting this error. Is there a way to find out what database object depends on this sequence?

edited Jun 20 '20 at 09:12

Community

asked Dec 09 '15 at 18:16

user3517179

Are you using SQL Manager? – Blue Eyed Behemoth Dec 09 '15 at 18:19
I am using shell itself – user3517179 Dec 09 '15 at 18:23
try `EXEC sp_fkeys 'seq_12129'` – Blue Eyed Behemoth Dec 09 '15 at 18:28
Isn't sp_fkeys SQL Server thing? I don't think so monetDB support this. – user3517179 Dec 09 '15 at 18:31
Yeah sorry. I didnt realize that you're using monetDB – Blue Eyed Behemoth Dec 09 '15 at 18:35
I have changed the title to make it clearer. – user3517179 Dec 09 '15 at 18:46

DROP SEQUENCE not working on MonetDB

0 Answers0