Re: How to delete all data from SQL table

2018-01-26 Thread Vladimir Ozerov
DROP TABLE + CREATE TABLE is the fastest way at the moment. TRUNCATE will be supported at some point in future. чт, 25 янв. 2018 г. в 15:56, Nikolay Izhikov : > Hello, guys. > > I wonder what is best way to delete all rows from table? > > Other RDBMS offer command like `TRUNCATE TABLE` or similar

How to delete all data from SQL table

2018-01-25 Thread Nikolay Izhikov
Hello, guys. I wonder what is best way to delete all rows from table? Other RDBMS offer command like `TRUNCATE TABLE` or similar. Is it would be faster if user execute `DROP TABLE XXX`, `CREATE TABLE XXX` instead of `DELETE FROM XXX`?