我需要检查一下列是否存在，如果它不存在添加它。从我的研究看来，sqlite不支持IF语句，而是应该使用case语句。
这是我到目前为止
SELECT CASE WHEN exists(select * from qaqc.columns where Name = "arg" and Object_ID = Object_ID("QAQC_Tasks")) = 0 THEN ALTER TABLE QAQC_Tasks ADD arg INT DEFAULT(0);
有任何想法吗？
您不能使用ALTER TABLE withcase。
您正在寻找获取表的列名:: ::
PRAGMA table_info(table-name);
在PRAGMA上查看本教程
This pragma returns one row for each column in the named table. Columns in the result set include the column name,data type,whether or not the column can be NULL,and the default value for the column. The “pk” column in the result set is zero for columns that are not part of the primary key,and is the index of the column in the primary key for columns that are part of the primary key.
