| Subject | Re: [firebird-support] How To Change Column DataType From Varchar To Integer ? |
|---|---|
| Author | Vishal Tiwari |
| Post date | 2015-04-22T09:00:18Z |
Is there no Alter like SQL available ?
On Wednesday, 22 April 2015 2:01 PM, "Mark Rotteveel mark@... [firebird-support]" <firebird-support@yahoogroups.com> wrote:
On Wed, 22 Apr 2015 09:28:09 +0100, "Tim Ward tdw@...
[firebird-support]" <firebird-support@yahoogroups.com> wrote:
True. But in this case I assume the happy case ;)
Mark
[firebird-support]" <firebird-support@yahoogroups.com> wrote:
> On 22/04/2015 09:26, Mark Rotteveel mark@...drop
> [firebird-support] wrote:
>>
>> Create a new column, assign/convert the values from the old column,
>> the old column, rename the new column (optional).
>>
> ... and sort out, manually, however many hundreds of dependencies you
> have (triggers, foreign keys, procedures, ...).
True. But in this case I assume the happy case ;)
Mark