![](https://cdn.userecho.com/characters/65.png?1)
0
Completed
Support "if not exists" clause in sqlite table and index creation.
It would be nice to support the "if not exists" clause for table and index creation when targeting sqlite.
Answer
![](https://cdn.userecho.com/characters/97.png?1)
Answer
Completed
Vertabelo already supports "if not exists" clause in these two statements.
In case of table creation, just expand "Additional properties" section and set "IF NOT EXISTS clause" to "Yes":
![](/s/attachments/13484/1/4/5fb7309eb561387881b249a4c1175334.png)
You'll then see your this clause in generated SQL:
![](/s/attachments/13484/1/4/ff419fcd679557c3ad3dac8be51bf145.png)
The same applies to index. Just set the property like this:
![](/s/attachments/13484/1/4/cfb6360ff1be39758d5b24749eb3f548.png)
and you'll see this in the SQL output:
![](/s/attachments/13484/1/4/8de11eff9e0eaba3f592dac766547d54.png)
I hope this helps.
In case of table creation, just expand "Additional properties" section and set "IF NOT EXISTS clause" to "Yes":
![](/s/attachments/13484/1/4/5fb7309eb561387881b249a4c1175334.png)
You'll then see your this clause in generated SQL:
![](/s/attachments/13484/1/4/ff419fcd679557c3ad3dac8be51bf145.png)
The same applies to index. Just set the property like this:
![](/s/attachments/13484/1/4/cfb6360ff1be39758d5b24749eb3f548.png)
and you'll see this in the SQL output:
![](/s/attachments/13484/1/4/8de11eff9e0eaba3f592dac766547d54.png)
I hope this helps.
Customer support service by UserEcho
In case of table creation, just expand "Additional properties" section and set "IF NOT EXISTS clause" to "Yes":
You'll then see your this clause in generated SQL:
The same applies to index. Just set the property like this:
and you'll see this in the SQL output:
I hope this helps.