techi eth wrote: > I have open the connection, created the table by using CREATE TABLE IF NOT > EXISTS , doing some operation & closing the connection. > > If I again open the connection & try to do table creation again (With same > table name & same database file) then what will be the behavior? > > I am expecting it should not create table & return me error, because their > is already table with same name exists.
RTFM <http://www.sqlite.org/lang_createtable.html>: | It is usually an error to attempt to create a new table in a database | that already contains a table of the same name. However, if the "IF | NOT EXISTS" clause is specified as part of the CREATE TABLE statement | and a table of the same name already exists, the CREATE TABLE command | simply has no effect (and no error message is returned). Regards, Clemens _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
