Wednesday 16 January 2013

clear down all records from table

use <databasename>
truncate table <tablename>
Posted by at

2 comments:

  1. Unknown16 January 2013 at 12:05

    If I'm not wrong this will work in case table doesn't have FK's.

    ReplyDelete
  2. KUK Solutions LTD27 January 2013 at 03:45

    you are right, I used above where I was using table outside of crm and I knew no FKs were involved :)

    ReplyDelete

Subscribe to: Post Comments (Atom)