CREATE TABLE PROBLEM

[info26]

Hi all,

I have a problem with SQLLite when I create a table.

If my sql cod is

CREATE TABLE mytable field....

It works

If I write

CREATE TABLE IF NOT EXISTS mytable fields...

Non viene creata la tabella anche se non esiste.

There is another way to check also if the table exists, or something wrong?

Thank's

[Jellicle]

SELECT name FROM sqlite_master
WHERE type='table'
ORDER BY name;

sqlite_master is a default (but usually hidden) table in all sqlite databases, apparently.

[Klaus]

Hi info26,

you can use the build-in function: revDatabaseTableNames(databaseID)
to get a list of ALL tables in a database and then check if your table name is in this list!


Best

Klaus

[Jellicle]

Hi info26,
you can use the build-in function: revDatabaseTableNames(databaseID)
to get a list of ALL tables in a database and then check if your table name is in this list!

Even better solution

Gerry

[info26]

Than'k all

Mimmo