SQL ALTER DROP query not working

Question

I am learning SQL online from w3school.com.

for droping a column
ALTER TABLE table_name DROP COLUMN column_name command is given in SQL ALTER page

i tried it in Try it yourself section provided by w3school.
but it's not working

I used

ALTER TABLE Customers
DROP COLUMN City;

I also try to do this query on compile online/sql.
but again it's not working.

so, can any one explain me where i am wrong.

Please include any error messages, exact details of what does or does not happen. Leave nothing out. We can only see what you show us. — MatBailie, Mar 24 '14 at 13:01
it shows Error1: could not prepare statements(1 near "DROP":syntax error); — singhiskng, Mar 24 '14 at 13:11
I think w3schools wont let you delete a column,the syntax is fine.Just install something like xampp adn practice offline. — Mihai, Mar 24 '14 at 13:14
Please tell us which DBMS you are using? Postgres? Oracle? Firebird? — , Mar 24 '14 at 13:40

score 1 · Accepted Answer · edited May 23 '17 at 12:11

1

Did you notice what it says in the brackets?

To delete a column in a table, use the following syntax (notice that some database systems don't allow deleting a column)

See the answers to these questions:

websql drop column with javascript

How to delete or add column in SQLITE?

W3schools uses websql. Try SQLFiddle instead.

edited May 23 '17 at 12:11

Community

1
1

answered Mar 24 '14 at 12:59

kintoki

318
2
11

Arasu Pandiyan · Answer 2 · 2014-06-11T05:31:51.347

0

try like this:

    use 'DatabaseName';
    ALTER TABLE Customers
    DROP COLUMN City;
    enter code here

edited Jun 11 '14 at 05:31

answered Mar 24 '14 at 13:03

Arasu Pandiyan

92
1
9

score 0 · Answer 3 · answered Mar 24 '14 at 13:21

0

The 'try it yourself' link you provided seems to be set up for testing a 'Select all' statement. It may not be a fully functional environment, and you may not have permission to run all statements.

answered Mar 24 '14 at 13:21

JamieA

1,984
4
27
38

SQL ALTER DROP query not working

3 Answers3