0

I need delete column from 

SELECT * FROM 36496839_woodensky.skladovekarty00002; ALTER TABLE skladovekarty00002 DROP COLUMN Description

Error Code: 1091. Can't DROP 'Description'; check that column/key exists

DB: MySql 5.1 Workbench Some issue ?

Improve this question
3
  • Can you add the create table Statement please? Commented Sep 5, 2014 at 20:18
  • 2
    You included the database name 36496839_woodensky in the SELECT statement. Is it as simple as you not having selected the database with USE 36496839_woodensky before the ALTER? Commented Sep 5, 2014 at 20:20
  • (in other words, does SELECT * FROM skladovekarty00002 also fail?) Commented Sep 5, 2014 at 20:21

1 Answer 1

Reset to default
1

Assuming your current database is not 36496839_woodensky, you will need to include the databasename in your alter table statement. For example:

ALTER TABLE 36496839_woodensky.skladovekarty00002 DROP COLUMN Description
Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.