仅当表不存在时才在 SQLite 中创建表

2021-12-08 00:00:00 sqlite create-table database-table

我只想在 SQLite 数据库中创建一个不存在的表.有没有办法做到这一点?如果表存在，我不想删除它，只有在它不存在时才创建它.

I want to create a table in a SQLite database only if doesn't exist already. Is there any way to do this? I don't want to drop the table if it exists, only create it if it doesn't.

推荐答案

来自 http://www.sqlite.org/lang_createtable.html:

CREATE TABLE IF NOT EXISTS some_table (id INTEGER PRIMARY KEY AUTOINCREMENT, ...);

相关文章