While dropping constraint named 123_5_pk_not_null, I am getting syntax error at the start of constraint name.
Query:
alter table table_name drop constraint 123_5_pk_not_null;
Error:
Syntax error at or near 123
Need to drop the constraint
Asked
Active
Viewed 57 times
1
James Z
- 12,209
- 10
- 24
- 44
krishna raja
- 11
- 1
-
2try double quotes around the constraint name – richyen Oct 27 '22 at 17:46
-
Does this answer your question? [Table or column name cannot start with numeric?](https://stackoverflow.com/questions/15917064/table-or-column-name-cannot-start-with-numeric) – James Z Oct 27 '22 at 17:46
-
Tried double quotes as well as single quotes. But didn’t work – krishna raja Oct 27 '22 at 18:41
-
`alter table table_name drop constraint "123_5_pk_not_null";` – The Impaler Oct 27 '22 at 19:13
-
The above query will not work – krishna raja Oct 27 '22 at 20:56