Best unofficial Apache Server developers community
Username
Forgot password?
Sign in with Twitter account
Sign in with Facebook account

Alternative for CREATE VIRTUAL TABLE IF NOT EXISTS

⇧
0
⇩
65 views

According to CREATE VIRTUAL TABLE syntax, IF NOT EXISTS clause is not available.

How should I handle the case when the virtual table already exists without using DROP TABLE IF EXISTS?

I want to use rtree and fts module.

c sqlite table virtual create
asked February 15, 2011 9:05 pm CST
afriza
posted via StackOverflow

1 Answers

⇧
0
⇩
 

You can use

select DISTINCT tbl_name from sqlite_master where tbl_name = ?

Then bind the virtual table name to your statement and call sqlite3_step(). If you get SQLITE_ROW back, then your table exists. To be certain that it is a virtual table, check the type column for 'virtual'.

answered February 15, 2011 9:29 pm CST
Seth

Your answer

Join with account you already have

Sign in with Twitter account
Sign in with Facebook account
Sign in with Google Friend Connect

Preview
Similar questions
Can I change the datatype for the "Create Table" field in the Show Create Table function in MySQL?
January 10, 2011
Deleting rows from SQLite table when no match exists in another table
February 11, 2011
MySQL Table inside Table or Alternative
January 29, 2011
Check if table exists
February 3, 2011
How do I create a virtual host on a CentOS
December 26, 2010
AIR and sqLite : if table exists conditional
January 5, 2011
PHP if a table table row exists
January 19, 2011
In sqlite How to add column in table if same column is not exists in table
January 8, 2011
Create table from select then alter table by adding an auto increment column in mysql
January 11, 2011
Mysql create table based on another table including indexes
January 25, 2011
MySQL create table containing values from a column in another table.
January 28, 2011
Postfix user not found in virtual alias table
October 17, 2010
Postfix - User unknown in virtual mailbox table + authentification failed
January 31, 2011
Create this table using my sql
February 1, 2011
C++, QT4 Sqlite: can't create table
February 15, 2011
How to use constants in SQL CREATE TABLE?
December 31, 2010
MySQL appears to DROP USER; but user still exists in mysql.users table
January 27, 2011
How to create index in two table mysql?
January 13, 2011
MySQL - Aren't these privileges enough to create a table?
January 3, 2011
Trigger: after insert create a new table
January 7, 2011
How to create paging with multi different table?
February 1, 2011
[Solved] SQL CREATE TABLE Error
January 9, 2011
Postgresql - CREATE TABLE SYNTAX ERROR USING LIKE -
February 2, 2011
MySQL table create taking way too long
February 11, 2011
Mysql create a table character sets
January 25, 2011
InnoDB Create Table/Sizing Troubles
January 26, 2011
Convert Simple T-SQL DDL to MySQL DDL (Create Table)
January 6, 2011
Mysql how to create optimum query for these table
February 11, 2011
Hibernate: hbm2ddl.auto does not create table
December 28, 2010
Rails Migration Create Table Primary Key
January 22, 2011