change schema of installed db

From: Parris Geiser <parris_at_walleye.esp.bellcore.com>
Date: 1995/10/03
Message-ID: <44s3k6$lic_at_athos.cc.bellcore.com>#1/1


Hi,

	We have a database installed at a customer site. In the
	next release of our sw we have to make the following types
	of changes to our schema:
	1. Add new columns to a table (both NULL and NOT NULL).
	2. Delete existing columns.
	3. Change the names of existing columns (some that appear in a key).
	4. Increasing/Decreasing the size of columns.
	5. Adding a new foreign key to a table.
	All of the tables contain data (of course).

	Does anyone have experience with these types of changes and can
	provide some words of wisdom?

	Thanks,
		parris geiser
Received on Tue Oct 03 1995 - 00:00:00 CET

Original text of this message