Cacher is the code snippet organizer for pro developers

IF EXISTS ( SELECT TOP 1 NULL 
            FROM sys.objects 
            WHERE object_id = OBJECT_ID(N'[Schema].[NewTable]') 
                AND type in (N'U'))
BEGIN
    -- No need to drop primary key.
    DROP TABLE [Schema].[NewTable]
END

IF NOT EXISTS (	SELECT TOP 1 NULL
                FROM sys.objects
                WHERE object_id = OBJECT_ID(N'[Schema].[NewTable]')
                  AND type in (N'U'))
BEGIN
	CREATE TABLE [Schema].[NewTable]
  (
    [Id] [TINYINT] NOT NULL,
    [Name] [VARCHAR](250) NOT NULL,
    CONSTRAINT [PK_NewTable] PRIMARY KEY CLUSTERED 
    (
      [Id] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  ) ON [PRIMARY]
END