Re: Database schema for univesal usage

From: David Cressey <david.cressey_at_earthlink.net>
Date: Thu, 26 May 2005 21:28:50 GMT
Message-ID: <mcrle.8352$M36.4042@newsread1.news.atl.earthlink.net>

I've never been able to understand why people say it costs lots of $$$ to add a column to a table.

The addition ALTER TABLE ... ADD COLUMN is straight forward. The fallout on existing queries should be minimal. Getting rid of NULLS in the new column is a data issue, not a technology issue.

Updating INSERTS and UPDATES to the table will take a little work, but its' no big deal. Where do the $$$ go?

<lauri.pietarinen_at_atbusiness.com> wrote in message news:1116990038.096646.86360_at_f14g2000cwb.googlegroups.com...
> spesific). If it costs $$$ to add a new column to a table then you
> propably start thinking in those terms.
Received on Thu May 26 2005 - 16:28:50 CDT