|
-- --------------------------------------------------
-- Entity Designer DDL Script for SQL Server 2005, 2008, and Azure
-- --------------------------------------------------
-- Date Created: 04/25/2011 11:12:12
-- Generated from EDMX file: c:\users\ugur\documents\visual studio 2010\Projects\MVC3EntityFramework\MVC3EntityFramework\Entity\YDModel.edmx
-- --------------------------------------------------
SET QUOTED_IDENTIFIER OFF;
GO
USE [YD];
GO
IF SCHEMA_ID(N'dbo') IS NULL EXECUTE(N'CREATE SCHEMA [dbo]');
GO
-- --------------------------------------------------
-- Dropping existing FOREIGN KEY constraints
-- --------------------------------------------------
-- --------------------------------------------------
-- Dropping existing tables
-- --------------------------------------------------
-- --------------------------------------------------
-- Creating all tables
-- --------------------------------------------------
-- Creating table 'YazarSet'
CREATE TABLE [dbo].[YazarSet](
[YazarId] int IDENTITY(1,1) NOT NULL,
[YazarAd] nvarchar(max) NOT NULL,
[MakaleSayisi] int NOT NULL
);
GO
-- --------------------------------------------------
-- Creating all PRIMARY KEY constraints
-- --------------------------------------------------
-- Creating primary key on [YazarId] in table 'YazarSet'
ALTER TABLE [dbo].[YazarSet]
ADD CONSTRAINT [PK_YazarSet]
PRIMARY KEY CLUSTERED ([YazarId] ASC);
GO
-- --------------------------------------------------
-- Creating all FOREIGN KEY constraints
-- --------------------------------------------------
-- --------------------------------------------------
-- Script has ended
-- --------------------------------------------------
|