Re: SQL: Create primary key for existing table
Ah, sorry I misunderstood you question.
When we deploy our software, one of the steps for the client is to run an SQL file which performs all the DB modifications. Its done this way as we dont have direct access to their database and it means we can just ship them an SQL file which run on their own servers.
There is no reason not to use a GUI tool if one is available, but I think its also good to understand the underlying SQL. Its very easy to press a button in a GUI without actually realising what its doing.