>The MAX_CLAUSES is empirically found magic number :) If you have a huge table, and you make lots of changes, it may take a long time, so it's much better to do just one ALTER TABLE command. Actually, it's mostly about changing structure, not adding fields, but I think, the same rule still applies. I have DataDictionary application, which allows to add fields/delete fields/change structure in our main database. It's a quite compicated program, so I don't want to show it all, but this idea is borrowed from there.
IC. I thought multiple 'add column' would syntax error.
Cetin