error when I try to "alter table"

[rileyharrison]

Hi, great program, loving it.

However, I'm having some issues.

I'm using verson 3.71.

I've imported a database with many table from sql server, and most everything seems to be working fine. But, on some the tables, I have the following issues.

When I right click the table name, and choose “alter table structure”, i get this message:

“could not read data for the table”

Then, I click “OK”, and it brings up the table structure.

Then, I try and set the field I use as an ID field to be a primary key, not null, auto increment, with no default value, and I get the message, “”Error No.1091 Can't DROP 'PRIMARY'; check that the column/key exists”

This really has me stumped. any insights?

thx!

[peterlaursen]

Why don't you try ver. 4.0? You can use the free version for that operation. It won't install over the one you have!

I remember someone had similar problems some time ago, but don't remember details.

the error message “Can't DROP 'PRIMARY'” might indicate that you have another field defined as PK, or just that sqlyog believes you have!

BTW:: which version of MySQL are you using … ?

[rileyharrison]

Hmm, it was my bosses call to go with 3.7.1, i'll have to ask him why.

And I said before that I had imported from a sql server database, actually it was from a mysql database. I get my sql's confused, lol.

And i'm using version 4.1.7 of mysql.

I think I will take a shot at trying 4.0, and seeing if it's simply a version issue.

Thx for the fast reply!

=)

[rileyharrison]

wow.. what do you know.. seems to work fine with version 4.0.

=)

I should have tried that in the first place.

Thanks again!

[Author]

Posts