text: ﻿/*
  Deployment script for Books
  
  This code was generated by a tool.
  Changes to this file may cause incorrect behavior and will be lost if
  the code is regenerated.
  */
  
  GO
  SET ANSI_NULLS, ANSI_PADDING, ANSI_WARNINGS, ARITHABORT, CONCAT_NULL_YIELDS_NULL, QUOTED_IDENTIFIER ON;
  
  SET NUMERIC_ROUNDABORT OFF;
  
  
  GO
  :setvar DatabaseName "Books"
  :setvar DefaultFilePrefix "Books"
  :setvar DefaultDataPath "c:\Program Files\Microsoft SQL Server\MSSQL11.SQLEXPRESS2012\MSSQL\DATA\"
  :setvar DefaultLogPath "c:\Program Files\Microsoft SQL Server\MSSQL11.SQLEXPRESS2012\MSSQL\DATA\"
  
  GO
  :on error exit
  GO
  /*
  Detect SQLCMD mode and disable script execution if SQLCMD mode is not supported.
  To re-enable the script after enabling SQLCMD mode, execute the following:
  SET NOEXEC OFF; 
  */
  :setvar __IsSqlCmdEnabled "True"
  GO
  IF N'$(__IsSqlCmdEnabled)' NOT LIKE N'True'
      BEGIN
          PRINT N'SQLCMD mode must be enabled to successfully execute this script.';
          SET NOEXEC ON;
      END
  
  
  GO
  USE [$(DatabaseName)];
  
  
  GO
  PRINT N'Dropping DF__Books__BookId__1273C1CD...';
  
  
  GO
  ALTER TABLE [dbo].[Books] DROP CONSTRAINT [DF__Books__BookId__1273C1CD];
  
  
  GO
  PRINT N'Creating PK_Books...';
  
  
  GO
  ALTER TABLE [dbo].[Books]
      ADD CONSTRAINT [PK_Books] PRIMARY KEY CLUSTERED ([BookId] ASC);
  
  
  GO
  PRINT N'Update complete.';
  
  
  GO
  