Alter table – good or bad?

(Nigel Rivett) You have a production table and wish to add or change a column. How do you do it? One way is to create a new table with the new structure, copy all the data across, delete the old table, rename the new table, apply constraint, foreign keys etc. A much simpler way is to use alte

Read More - Register for Free Membership