feature request

Hi i don't know exactly the sql terms for that

but if yiu have something like

create table emails(email varchar(1000)) you can't just give it a unique index without doing it partially

something like

alter table emails add unique(email(50)); i wish there is a presentation for thing Heidi sql

yes you may give it an amount somehow but it's not visible in Indexes tab

If you are using the latest build of HeidiSQL that should be displayed in the "Indexes" tab of the table editor. You need to collapse the index to see the columns, then you see the subpart length in the "Type / length" column.

ohhhhh .

it's my fault i did not c it before thanks