I want to alter the primary key name programmatically after migration of the database. As a first step I went into EDBManager and carried out the operation on one table thinking I'll just grab the sql it generates.

I dropped the primary key constraint, recreated it with its new name and clicked OK - the table was altered but I can't see where the generated sql is. Can you reveal its secret location?

Roy Lambert

Roy,

<< I want to alter the primary key name programmatically after migration of
the database. As a first step I went into EDBManager and carried out the
operation on one table thinking I'll just grab the sql it generates.

I dropped the primary key constraint, recreated it with its new name and
clicked OK - the table was altered but I can't see where the generated sql
is. Can you reveal its secret location? >>

Main menu - Explorer/SQL History

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim


Nice - just one comment - the clear history button - you have to close that form down and reopen before the history vanishes.

Roy Lambert

Roy,

<< Nice - just one comment - the clear history button - you have to close
that form down and reopen before the history vanishes. >>

Already fixed.  I noticed that one the next day after the 1.06 release.  You
get 3 guesses as to the last feature that was added to the EDB Manager right
before the testing and builds started.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim


>Already fixed. I noticed that one the next day after the 1.06 release. You
>get 3 guesses as to the last feature that was added to the EDB Manager right
>before the testing and builds started.

Making a cup of tea after the computer boots?

Roy Lambert

Roy,

<< Making a cup of tea after the computer boots? >>

Nah, tea is a regular thing - the only thing that changes is switching to
decaf in the afternoon.

--
Tim Young
Elevate Software
www.elevatesoft.com