Re: ALTER Field - How can I avoid dependencies ? - Article 185 - go-pugleaf

Article View: borland.public.interbase.sql

Article #185

Back to borland.public.interbase.sql Previous Next

Re: ALTER Field - How can I avoid dependencies ?

#185

From: Pavel Kutakov
Date: Fri, 18 Jul 2008 17:42

25 lines
1719 bytes

Only some third-party tools (our IBStudio for example) can build the script 
to do this. This script contains several statements to drop dependend 
objects, make changes in the table and recreate deleted object again. Of 
course, this will work only when you are doing change to compatible datatype 
so your existing SPs will not fail.

-- 
Best regards.
Pavel Kutakov
SQLLY Development
http://www.sqlly.com


> I need to ALTER MyField
> TYPE Decimal(8,2) to TYPE Decimal(10,2)
> but there are dependencies.
>
> I would have to drop quite a few other things 1st
> Then only make my desired change
> .. and then recreate all the other dropped stuff again
>
> Is there not a way to avoid all that?
>
> Thanks q
>

Technical Details

Message-ID: <4880d5fa@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news2.google.com!border1.nntp.dca.giganews.com!border2.nntp.dca.giganews.com!nntp.giganews.com!newspeer1.nac.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

References: <487f9ff9@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
From: "Pavel Kutakov" <pvk@sqlly.com>
Newsgroups: borland.public.interbase.sql
References: <487f9ff9@newsgroups.borland.com>
Subject: Re: ALTER Field - How can I avoid dependencies ?
Date: Fri, 18 Jul 2008 21:42:20 +0400
Lines: 27
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Response
X-Antivirus: avast! (VPS 080718-1, 18.07.2008), Outbound message
X-Antivirus-Status: Clean
NNTP-Posting-Host: 195.170.56.126
Message-ID: <4880d5fa@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1216402938 195.170.56.126 (18 Jul 2008 10:42:18 -0700)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news2.google.com!border1.nntp.dca.giganews.com!border2.nntp.dca.giganews.com!nntp.giganews.com!newspeer1.nac.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail
X-Original-Bytes: 1637

Reply to Parent Message