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.
  • Tags: How to drop tables if it exists before creating the table?
    Updated on: October 2024