MVC7amThundersBatch

-- -------------------------------------------------- -- Entity Designer DDL Script for SQL Server 2005, 2008, 2012 and Azure -- -------------------------------------------------- -- Date Created: 03/02/2021 07:27:01 -- Generated from EDMX file: D:\Projects\MVC7amThundersBatch\ModelBasedApproach\Models\Model1.edmx -- -------------------------------------------------- SET QUOTED_IDENTIFIER OFF; GO USE [AmithDb]; 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 'Staffs' CREATE TABLE [dbo].[Staffs] ( [Id] int IDENTITY(1,1) NOT NULL, [StaffName] nvarchar(max) NOT NULL, [Description] nvarchar(max) NOT NULL ); GO -- -------------------------------------------------- -- Creating all PRIMARY KEY constraints -- -------------------------------------------------- -- Creating primary key on [Id] in table 'Staffs' ALTER TABLE [dbo].[Staffs] ADD CONSTRAINT [PK_Staffs] PRIMARY KEY CLUSTERED ([Id] ASC); GO -- -------------------------------------------------- -- Creating all FOREIGN KEY constraints -- -------------------------------------------------- -- -------------------------------------------------- -- Script has ended -- --------------------------------------------------