Hi,

I was wondering if anyone can please give me an example on how to see if a
table exists within EDB?

Looking at the manual it says "This property is no longer necessary. To
determine if a table or view exists in a database, query the special
Information Schema for the database.", but I can't find any additional in
the manual about how to query the Special Information Schema.

Thanks & Regards

Adam.

Adam,

You can test if a table exists searching the Information Schema, as follows:

  SELECT * FROM Information.Tables WHERE Name = 'YourTableName'


You can also define a Delphi function, like this:

Function TableExists(TableName: string): boolean;
begin
  Result :=
    EDBDatabase1.Execute(
      'SELECT Version '+
      'FROM Information.Tables '+
      'WHERE Name =' + QuotedStr(TableName)
    )=1 ;
end;

--
Fernando Dias
[Team Elevate]

Adam

>>Looking at the manual it says "This property is no longer necessary. To determine if a
table or view exists in a database, query the special
Information Schema for the database.", but I can't find any additional in the manual about
how to query the Special Information Schema.

The following query will result in 1 if the <TableName> table exists, otherwise 0.

select Count(*) from Information.Tables
 WHERE Name = :TableName

Richard Harding

Hi Guys,

And thanks for your help! Greatly apprecaited...

Adam.

> I was wondering if anyone can please give me an example on how to see
> if a table exists within EDB?

You might also want to check out the "extensions" newsgroup.  There's a
TableExists function posted about a year back that might come in handy.

--
David Cornelius
CorneliusConcepts.com