Is that not a bad example Simon? Why would you have to change the 'select *'? Suppose you had a backup for a table with 50 columns insert into bkup select * from tbl where ....; would surely be easier to maintain than the alternative. It would save having to change the backup sql every time you decided to restructure the tables.