#13 Primary Key Wizard

Snapshot
open
nobody
3
2004-01-06
2002-08-20
No

Is it possible to right click on a field and set it to be a
primary key..
This would make it Not null and add it as a contraint in
one shot.
There might also be a way of creating the whole
Generator etc in one ;-)

Discussion

  • Paul Gittings
    Paul Gittings
    2002-08-21

    Logged In: YES
    user_id=61098

    Maybe a new datatype, eg AUTOINCREMENT, which when added to
    a table results in dialog comming up asking for the
    generator, trigger name and real datatype (default
    numeric(18,0)??). The names should default to something like
    GEN_tableName_columnName and
    TRIG_INSERT_INC_tableName_columnName.

    User should be able to default prefixes, and datatype and
    initial value.

     
  • Tilo Muetze
    Tilo Muetze
    2002-09-18

    • milestone: --> Snapshot
    • priority: 5 --> 3
    • assigned_to: nobody --> tmuetze
     
  • Tilo Muetze
    Tilo Muetze
    2002-09-18

    Logged In: YES
    user_id=152149

    Hi,
    good idea. It will be included in one of the next snapshots.

    Regards,
    Tilo Muetze

     
  • Tilo Muetze
    Tilo Muetze
    2002-09-18

    Logged In: YES
    user_id=152149

    Yes I thought about something like this. Thanks again for
    your hints.

     
  • Tilo Muetze
    Tilo Muetze
    2004-01-06

    • assigned_to: tmuetze --> nobody