> > DROP COLUMN and RENAME COLUMN are relatively easy for tables that lack > indexes, triggers, views, foreign key references, CHECK constraints, > and other constructs that might reference the dropped or renamed > column. Reliably finding every use of a column name and changing it > can be tricky. The problem is more acute for dropping a column - what > do you do then, change each reference to NULL?
it may be okay to say: If it is referenced, we may live with an error. "Can't drop column xxx as it is used in trigger yyy." Most columns for us are not referenced in any way. Just data columns. Sincerely Christian -- Read our blog about news on our plugins: http://www.mbsplugins.de/
