|
|
Posted by Hugo Kornelis on 09/15/05 01:13
On 13 Sep 2005 17:06:25 -0700, BD wrote:
>I am asked to do this on a very regular basis.
>
>The logic I normally go through is as follows:
(snip)
>I would recommend making a SQL script for this process, and keeping it
>as a template for future use.
Hi BD,
If you make a generic template, then you might wish to include dropping
and recreation of foreign key constraints that reference the table to be
changed. You omitted that from your shortlist.
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)
Navigation:
[Reply to this message]
|