Thread: query from Murty

SELECT * FROM pg_tables WHERE tablename NOT LIKE 'pg_%'

will list the tables present in the database... you can
go from there.

Cheers,
Joe

> "D.N.MURTY" wrote:
> 
> I created a programme in Visual Basic(IIS Application) to create a table in
> the Access Database based on inputs from the user.  However I am not able to
> find out a way to" make the code check  for existing tables" to avoid
> dupilaction of tables by the same name.
> Do You have a solution to this problem ?
> 
> my e-mail number : dnmurty@vsnl.com
> 

-- 
Joe Shevland
Principal Consultant
KPI Logistics Pty Ltd
http://www.kpi.com.au
mailto:shevlandj@kpi.com.au

> "D.N.MURTY" wrote:
> 
> I created a programme in Visual Basic(IIS Application) to create a
> table in the Access Database based on inputs from the user.  However I
> am not able to find out a way to" make the code check  for existing
> tables" to avoid dupilaction of tables by the same name.
> Do You have a solution to this problem ?
> 
> my e-mail number : dnmurty@vsnl.com
> 

Isn't there some kind of meta function such as odbc's SQLTables
available to your application?

Byron