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

home / software / tips and tricks / 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.

alt="Add your business to our listing Free"