· 8 years ago · Dec 15, 2017, 04:58 PM
1drop database if exists dbo;
2
3create database dbo;
4
5create table dbo.a_table (a_table_a_field int not null);
6
7IF OBJECT_ID('a_table') IS NOT NULL DROP TABLE dbo.a_table
8IF EXISTS(SELECT * FROM sys.databases WHERE name='dbo') DROP DATABASE dbo
9
10CREATE DATABASE dbo;
11
12CREATE TABLE dbo.a_table (a_table_a_field INT NOT NULL);