-- -------------------------------------------------- -- Entity Designer DDL Script for SQL Server 2005, 2008, and Azure -- -------------------------------------------------- -- Date Created: 02/25/2012 21:41:03 -- Generated from EDMX file: E:\Web_Hostings\dev\DojoTree\DojoTree\Models\TreeModel.edmx -- -------------------------------------------------- SET QUOTED_IDENTIFIER OFF; GO USE [TreeData]; GO IF SCHEMA_ID(N'dbo') IS NULL EXECUTE(N'CREATE SCHEMA [dbo]'); GO -- -------------------------------------------------- -- Dropping existing FOREIGN KEY constraints -- -------------------------------------------------- -- -------------------------------------------------- -- Dropping existing tables -- -------------------------------------------------- IF OBJECT_ID(N'[dbo].[Nodes]', 'U') IS NOT NULL DROP TABLE [dbo].[Nodes]; GO -- -------------------------------------------------- -- Creating all tables -- -------------------------------------------------- -- Creating table 'Nodes' CREATE TABLE [dbo].[Nodes] ( [Id] int IDENTITY(1,1) NOT NULL, [ParentId] int NOT NULL, [NodeName] nvarchar(max) NOT NULL ); GO -- -------------------------------------------------- -- Creating all PRIMARY KEY constraints -- -------------------------------------------------- -- Creating primary key on [Id] in table 'Nodes' ALTER TABLE [dbo].[Nodes] ADD CONSTRAINT [PK_Nodes] PRIMARY KEY CLUSTERED ([Id] ASC); GO -- -------------------------------------------------- -- Creating all FOREIGN KEY constraints -- -------------------------------------------------- -- -------------------------------------------------- -- Script has ended -- --------------------------------------------------
By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.
If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.
This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)