Detect if a table exists

Question

In SQL Server you can write SQL to check if a table exists. How can I do that for ADS?

I have a need to write some Delphi code to say if table exists do this else this...

Answer 1

The system procedure sp_GetTables can tell you what tables exist in the directory that you connected to:

EXECUTE PROCEDURE sp_GetTables( NULL, NULL, NULL, 'TABLE' )

A non-SQL solution would be to use the AdsCheckExistence API.