On Tue, Sep 27, 2011 at 1:51 PM, Gauthier, Dave <dave.gauthier@intel.com> wrote:
> How does one make a metadata change to a DB that's actively being used.
> Specifically, I want to drop a view, drop some columns from a table that's
> used in the view, recreate the view without those columns.
BEGIN TRANSACTION;
DROP VIEW someView ...;
ALTER TABLE DROP COLUMN someColumn1, DROP COLUMN someColumn2;
CREATE VIEW someView AS ...;
COMMIT; --Wait for pre-existing locks to complete and hope your client
app doesn't break.
--
Regards,
Richard Broersma Jr.