server MySQL 4.1 - 35
Created a table test_1 with a Primary key named prim_1
but it was not scripted in Script Generation
CREATE TABLE `test_1` (
`c1` varchar(25) NULL,
PRIMARY KEY(`c1`)
)
In MySQL (including 6.0), even if we provide a contraint name, it will not assign this name to the contraint (will not store it in the database). I tried to script the name but then changed it back because it creates confusion.
This is a long standing issue. In some cases you want the name, and some cases you don't. For MySQL specifically not sure if it matters. There is only one primary key.
This is a long standing issue. In some cases you want the name, and some cases you don't. For MySQL specifically not sure if it matters. There is only one primary key.
Issue #1380 |
Closed |
Won't Fix |
Resolved |
Completion |
No due date |
No fixed build |
No time estimate |
In MySQL (including 6.0), even if we provide a contraint name, it will not assign this name to the contraint (will not store it in the database). I tried to script the name but then changed it back because it creates confusion.