Home / Software / Tips and Tricks / How to drop tables if it exists before creating the table?

How to drop tables if it exists before creating the table?

Updated:  07/13/2010 11:07 AM
Author:  Shiju Mathews

Status:    Resolved.


While design phases it is advantage to add some script to drop tables if it exists. Use the following script to for this task.



Where
  • HumanResource is the schema name
  • Employee is the table name

    This script will first delete the table if it exist, and then create the table.
  •