sql could not drop constraint when there is no constraint

Question

I want to alter my table and drop a column which i know there is no data in it(because I just created it) now I want to delete it and it says

"SQL Error (3727): Could not drop constraint. See previous errors."

I use the following code:

    ALTER TABLE Object DROP WAddress

Try ALTER TABLE Object DROP COLUMN WAddress? In other words, aren't you missing the "COLUMN" keyword? — SuaveIncompetence
– SuaveIncompetence, Commented Jun 21, 2017 at 5:34

SuaveIncompetence · Accepted Answer · 2017-06-21 05:43:46Z

6

Your query is missing the "COLUMN" keyword. Use:

ALTER TABLE Object DROP COLUMN WAddress

The reason it was throwing the error about the constraint, is that it was expecting that WAddress was the name of a constraint on the table because the keyword "COLUMN" was missing.

answered Jun 21, 2017 at 5:43

SuaveIncompetence

5233 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Keyur Panchal · Accepted Answer · 2017-06-21 06:24:39Z

3

Below are the syntax to drop column(s) from table:
Drop single column:

ALTER TABLE table_name DROP COLUMN column_name;

Drop multiple columns for SQL Server:

ALTER TABLE table_name DROP COLUMN (column_name1, column_name2);

For Oracle:

ALTER TABLE table_name DROP (column_name1, column_name2);

In your case you want to drop a single column so COLUMN keyword is required after DROP.
If you want to drop multiple columns, you can omit COLUMN keyword based on DB that you are using.

edited Jun 21, 2017 at 6:24

answered Jun 21, 2017 at 5:47

Keyur Panchal

1,4121 gold badge11 silver badges15 bronze badges

2 Comments

Pratik Patel Over a year ago

I think for multiple columns, your syntax won't work. It should be ALTER TABLE table_name DROP COLUMN column_name1, column_name2;

SuaveIncompetence Over a year ago

PratikPatel is right, try: CREATE TABLE #Object ( [a] INTEGER ,[b] INTEGER ,[c] INTEGER ) ALTER TABLE [#Object] DROP COLUMN a,b

Collectives™ on Stack Overflow

sql could not drop constraint when there is no constraint

2 Answers 2

Comments

2 Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Related