Check if Table exists

bart57 · Post by **bart57** » 19.07.2006, 10:40

Hi,

How can I easily check if a Table exists ? (No Select and No TZTable.open + exception) ?

thx

gto · Post by **gto** » 19.07.2006, 17:48

TZConnection have a GetTableNames function, which returns the name of all tables.. try it

zippo · Post by **zippo** » 19.07.2006, 19:06

At least two ways:

Execute a query "Show Tables like "teblename%" and see if there's your table.

Use ZSQLMetadata component to do it.

bart57 · Post by **bart57** » 20.07.2006, 09:32

Thank you,

it works fine :-)

bart57 · Post by **bart57** » 21.07.2006, 12:40

Hi Zippo,

how does it work with ZSQLMetadata, have you an example please?

thx

Terence · Post by **Terence** » 22.07.2006, 21:28

Var List:TStringList;
List:= TStringList.Create;
Connection.GetTableNames('tablename%',string; List);
......
List.Free;

bart57 · Post by **bart57** » 24.07.2006, 07:27

I know how it works with GetTableNames but I ask how it works with ZSQLMetadata

Terence · Post by **Terence** » 24.07.2006, 07:31

GetTableNames is implemented in/as ZSqlMetaData

bart57 · Post by **bart57** » 24.07.2006, 10:04

thx but GetTableNames give me all the tables back !
I just want the tables from one shema !

Terence · Post by **Terence** » 24.07.2006, 10:17

That is there is a filter param for that method, check
Connection.GetTableNames('shema%',List);

bart57 · Post by **bart57** » 24.07.2006, 11:05

thx,

I have a problem: the name of my shema is BISS, I try

zConnection1.GetTableNames('BISS%',List);

but it doesn't work :-(

Terence · Post by **Terence** » 24.07.2006, 11:55

Then apply my patch on Testing branch,compile zeos and call
ZConnection.GetTableNames('BISS','',List);
afterwards.

If it works for you, i will commit.

bart57 · Post by **bart57** » 24.07.2006, 12:30

thx a lot Terence ,

It works great with your modified Procedure!

Terence · Post by **Terence** » 24.07.2006, 12:35

which databse did you use - i need the info just for commit statment.

bart57 · Post by **bart57** » 24.07.2006, 14:46

I use Oracle 10g