14/06/2014

Empty Long Table In SQL

To empty large table in SQL, Usually it need looooong time to finished. but you can do this by using the below command:

set rowcount 1;
truncate table TABLE_NAME;


No comments:

Post a Comment