Post reply

Clear data

  • October 28, 2011 at 4:54 am

    #245301

    How to clear all the data in a table with out deleting the database of a particular tables starts with "%".

  • October 28, 2011 at 4:59 am

    #1400555

    Delete from table_name

    Truncate table table_name

    Are you trying to remove all the rows from a certain table without deleting the actual table??

  • October 28, 2011 at 5:01 am

    #1400556

    yes , we want a empty tables for testing

  • October 28, 2011 at 5:04 am

    #1400557

    Then use this

    truncate table table_name

    or

    delete from table_name

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply