about clear table quickly

[Former Member]

Hi

Is there any way to clear table quickly in open sql? now i use "delete from table" to clear table,but it is so slowly.

our database is sql server.

thank you!

[Former Member]

Hi

Is there any way to clear table quickly in open sql? now i use "delete from table" to clear table,but it is so slowly.

our database is sql server.

thank you!

[Former Member]

Hi qinlei,

you may try using TRUNCATE TABLE in a Native SQL statement.

I hope this helps. Kind regards,

Alvaro

[Former Member]

thank you very much