当前位置:首页 > 数据库 > SQlite

SQLite - TRUNCATE TABLE

https://www.tutorialspoint.com/sqlite/sqlite_truncate_table.htm

Unfortunately, no TRUNCATE TABLE in SQLite but DELETE to delete complete data from an existing table,
though it is recommended to use DROP TABLE to drop complete table and re-create it once again.

If you are using DELETE TABLE to delete all the records, it is recommended to use VACUUM to clear unused space.

DELETE FROM table_name;
VACUUM;
DROP TABLE table_name;

SQLite - TRUNCATE TABLE

标签:data   from   trunc   htm   rom   sqlite   creat   lsp   truncate   

本文系统来源:http://www.cnblogs.com/cnblogist/p/6121527.html


【说明】本文章由站长整理发布,文章内容不代表本站观点,如文中有侵权行为,请与本站客服联系(QQ:254677821)!