1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
|
--
-- Created by SQL::Translator::Generator::Role::DDL
-- Created on Tue Sep 16 19:48:36 2014
--
--
-- Turn off constraints
--
IF EXISTS (SELECT name FROM sysobjects WHERE name = 'HasDateOps' AND type = 'U') ALTER TABLE [HasDateOps] NOCHECK CONSTRAINT all;
IF EXISTS (SELECT name FROM sysobjects WHERE name = 'Gnarly' AND type = 'U') ALTER TABLE [Gnarly] NOCHECK CONSTRAINT all;
--
-- Drop tables
--
IF EXISTS (SELECT name FROM sysobjects WHERE name = 'HasDateOps' AND type = 'U') DROP TABLE [HasDateOps];
IF EXISTS (SELECT name FROM sysobjects WHERE name = 'Gnarly' AND type = 'U') DROP TABLE [Gnarly];
--
-- Table: [Gnarly]
--
CREATE TABLE [Gnarly] (
[id] int NOT NULL,
[name] varchar NOT NULL,
[literature] text NULL,
[your_mom] blob NULL,
CONSTRAINT [Gnarly_pk] PRIMARY KEY ([id])
);
--
-- Table: [HasDateOps]
--
CREATE TABLE [HasDateOps] (
[id] int NOT NULL,
[a_date] datetime NOT NULL,
[b_date] datetime NULL,
CONSTRAINT [HasDateOps_pk] PRIMARY KEY ([id])
);
|
