Home Forums SQL Server 2005 Business Intelligence Drop and Create table or Trunc table RE: Drop and Create table or Trunc table

  • November 11, 2013 at 5:30 am

    #1665434

    As you mentioned there is no Foreign Keys so truncate and load is better.

    1. If you drop the table again you have to create the table and load.

    2. You have drop the Table if there is any changes in he table structure from previous load that time it is better way but in your case truncate and load is better.