topic Re: about clear table quickly in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/about-clear-table-quickly/m-p/7179269#M1518310 <HTML><HEAD></HEAD><BODY><P>thank you very much</P></BODY></HTML> Wed, 04 Aug 2010 00:50:18 GMT Former Member 2010-08-04T00:50:18Z about clear table quickly https://community.sap.com/t5/application-development-and-automation-discussions/about-clear-table-quickly/m-p/7179267#M1518308 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>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.</P><P></P><P>our database is sql server.</P><P></P><P>thank you!</P></BODY></HTML> Tue, 03 Aug 2010 01:18:18 GMT https://community.sap.com/t5/application-development-and-automation-discussions/about-clear-table-quickly/m-p/7179267#M1518308 Former Member 2010-08-03T01:18:18Z Re: about clear table quickly https://community.sap.com/t5/application-development-and-automation-discussions/about-clear-table-quickly/m-p/7179268#M1518309 <HTML><HEAD></HEAD><BODY><P>Hi qinlei,</P><P>you may try using TRUNCATE TABLE in a Native SQL statement.</P><P>I hope this helps. Kind regards,</P><P>Alvaro</P></BODY></HTML> Tue, 03 Aug 2010 10:53:43 GMT https://community.sap.com/t5/application-development-and-automation-discussions/about-clear-table-quickly/m-p/7179268#M1518309 Former Member 2010-08-03T10:53:43Z Re: about clear table quickly https://community.sap.com/t5/application-development-and-automation-discussions/about-clear-table-quickly/m-p/7179269#M1518310 <HTML><HEAD></HEAD><BODY><P>thank you very much</P></BODY></HTML> Wed, 04 Aug 2010 00:50:18 GMT https://community.sap.com/t5/application-development-and-automation-discussions/about-clear-table-quickly/m-p/7179269#M1518310 Former Member 2010-08-04T00:50:18Z