Question

是否在Kalkite(C#.NET)有相应的指挥?

。

Answer 1

无。

一种办法是,在

select  delete from   || name ||   where ID = 42 
from sqlite_master
where type =  table

这将为每个表格生成<代码>delete,然后作为文字加以捕获和操作。

但一般来说,数据库开发商了解其表格名称的好意如下:

Answer 2

删除所有内容。

.output wipe.sql
.print BEGIN TRANSACTION;
SELECT  DELETE FROM   || name ||   WHERE id="idnumber"; 
FROM sqlite_master
WHERE type =  table ;
.print COMMIT;
.print VACUUM;
.output
-- .read wipe.sql

认识到如果你离开<代码>WHERE id='id number,这将毁掉你的数据库!

Answer 3

我用于有活力的方案目的的一种方法正在形成一系列的表格名称和空白。

e.g.

页: 1

var array = [ table1 , table2 , table3 ]

for item in array

{
    
var stringToDeleteTables:String = "DELETE FROM \(item) [optional where clause]"

//run the command on the database

}

I hope this helps someone. Great for things such as sign outs or clearing search data. You can even make an extension of an array and call it as a function.

Answer 4

你们可以尝试:

//You can do it with the following DANGEROUS commands:

PRAGMA writable_schema = 1;
delete from sqlite_master where type =  table ;
PRAGMA writable_schema = 0;



 //you then want to recover the deleted space with
 VACUUM

//and a good test to make sure everything is ok
 PRAGMA INTEGRITY_CHECK;

Hope it will be useful for you.

友情链接