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

Heiko


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

Roy Lambert [Team Elevate]

Roy

>>I argued long, hard and passionately for them

do you remember the thread ?

Heiko

> 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

Heiko


It was off newsgroup.

Roy Lambert

David


The whole table ones yes, the column ones no.

Roy Lambert [Team Elevate]

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

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


See new submissions in the elevatedb.extensions group.

--
David Cornelius
CorneliusConcepts.com

David

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

Cool...thanks for that !

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]