SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE DATABASE [royal] GO USE [royal] GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[RoomInfo]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[RoomInfo]( [RoomNo] [int] NOT NULL,