Re: Re: Regular Expression Problem

OK, I have this working for the most part. However, I have one question how do I get USING INDEX TABLESPACE INDEXES added after the closing )?

s/(PRIMARY KEY)/CONSTRAINT PK_$table $1/;
[download]

can anyone help.

Thanks,

Bobby

Comment on Re: Re: Regular Expression Problem Download Code

Replies are listed 'Best First'.
Re: Re: Re: Regular Expression Problem by rdfield (Priest) on Dec 02, 2002 at 18:22 UTC
`s/(PRIMARY KEY$[^)]$)/CONSTRAINT PK_$table $1 USING INDEX TABLESPACE + INDEXES/;` [download] as long as you have the primary key columns defined within brackets after "PRIMARY KEY". rdfield	[reply] [d/l]

Replies are listed 'Best First'.
Re: Re: Re: Regular Expression Problem by rdfield (Priest) on Dec 02, 2002 at 18:22 UTC
`s/(PRIMARY KEY\([^)]\))/CONSTRAINT PK_$table $1 USING INDEX TABLESPACE + INDEXES/;` [download] as long as you have the primary key columns defined within brackets after "PRIMARY KEY". rdfield	[reply] [d/l]