in reply to Inserting in an unknown point
use strict; my $sql='"ALTER TABLE "ARSAMS"."TCMD_HEADER" ADD CONSTRAINT FK_TCMD_HE +A_OWNER_CONTAINE (CONTAINER_OWNER_CD) REFERENCES ARSAMS.CONTAINER_OWN +ER_CODE (CONTAINER_OWNER_CD)"'; my $fk_table_name="FK_TCMD_HEA_OWNER_CONTAINE"; $sql=~s/($fk_table_name)/$1 FOREIGN KEY/; print $sql;
CU
Robartes-
|
|---|
| Replies are listed 'Best First'. | |
|---|---|
|
Re: Re: Inserting in an unknown point
by curtisb (Monk) on Oct 04, 2002 at 15:20 UTC |