Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 10 of 11 total
Thread IF (NOT) EXISTS
Tue, Jun 24 2008 3:15 AMPermanent Link

Heiko Knuettel
CREATE ... IF NOT EXISTS
ALTER ... IF EXISTS
DROP ... IF EXISTS
ADD ... IF NOT EXISTS

etc. pp.

I know I can query the information schema, but I am missing them. They were very handy.
Any chance to get them back ?

TIA,

Heiko
Tue, Jun 24 2008 5:22 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Heiko


I know the answer to that since I argued long, hard and passionately for them - its NO.

Roy Lambert [Team Elevate]
Tue, Jun 24 2008 7:41 AMPermanent Link

Heiko Knuettel
Roy

>>I argued long, hard and passionately for them

do you remember the thread ?

Heiko
Tue, Jun 24 2008 1:09 PMPermanent Link

"David Cornelius"
> I know I can query the information schema, but I am missing them. They
> were very handy.
> Any chance to get them back ?


You could build a function pretty easily.

--
David Cornelius
CorneliusConcepts.com
Tue, Jun 24 2008 1:53 PMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Heiko


It was off newsgroup.

Roy Lambert
Tue, Jun 24 2008 1:53 PMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

David


The whole table ones yes, the column ones no.

Roy Lambert [Team Elevate]
Tue, Jun 24 2008 3:24 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Roy,

<< The whole table ones yes, the column ones no. >>

How are they different ?  Both rely on simply querying the Information
schema and building a DDL statement accordingly.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tue, Jun 24 2008 4:50 PMPermanent Link

"David Cornelius"
> The whole table ones yes, the column ones no.


See new submissions in the elevatedb.extensions group.

--
David Cornelius
CorneliusConcepts.com
Tue, Jun 24 2008 4:56 PMPermanent Link

Heiko Knuettel
David

>>See new submissions in the elevatedb.extensions group.

Cool...thanks for that !
Wed, Jun 25 2008 2:59 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Tim

><< The whole table ones yes, the column ones no. >>
>
>How are they different ? Both rely on simply querying the Information
>schema and building a DDL statement accordingly.

I was looking at it from a viewpoint of I could write a function to carry out the table level ones, but you need to build the sql for the column level ones. So I could have a function CreateTableIfNotExists(tablename) and it is self contained much as the DBISAM syntax is but I couldn't write the equivalent of ADD COLUMN IF NOT EXISTS. If I want to do that I have to create the whole sql statement.

Roy Lambert [Team Elevate]
Page 1 of 2Next Page
Jump to Page:  1 2
Image