Что не так?

ALTER TABLE dbo.[Layer]
ADD [ScaleID] int NULL

ALTER TABLE dbo.[Object]
ADD [ScaleID] int NULL

ALTER TABLE dbo.[Sign]
ADD [ScaleID] int NULL

ALTER TABLE dbo.[ObjectProperties]
ADD [ScaleID] int NULL

ALTER TABLE dbo.[ObjectTypeProperties]
ADD [ScaleID] int NULL

ALTER TABLE dbo.[Scale]
ADD [ValueMax] float NULL

update dbo.[Scale]
set [ValueMax] = 0
where [ValueMax] is null

ALTER TABLE dbo.[Point]
ADD [Angle] float NULL

update dbo.[Point]
set [Angle] = 0
where [Angle] is null

-- первичные ключи
ALTER TABLE [dbo].[BaseMap]
ADD CONSTRAINT [BaseMap_pk] PRIMARY KEY ([ID])

ALTER TABLE [dbo].[BaseMapFile]
ADD CONSTRAINT [BaseMapFile_pk] PRIMARY KEY ([ID])

ALTER TABLE [dbo].[BasePoint]
ADD CONSTRAINT [BasePoint_pk] PRIMARY KEY ([ID])

ALTER TABLE [dbo].[Layer]
ADD CONSTRAINT [Layer_pk] PRIMARY KEY ([ID])

ALTER TABLE [dbo].[LayerImage]
ADD CONSTRAINT [LayerImage_pk] PRIMARY KEY ([ID])

ALTER TABLE [dbo].[LayersGroup]
ADD CONSTRAINT [LayersGroup_pk] PRIMARY KEY ([ID])

ALTER TABLE [dbo].[License]
ADD CONSTRAINT [License_pk] PRIMARY KEY ([ID])

ALTER TABLE [dbo].[Map]
ADD CONSTRAINT [Map_pk] PRIMARY KEY ([ID])

ALTER TABLE [dbo].[Object]
ADD CONSTRAINT [Object_pk] PRIMARY KEY ([ID])

ALTER TABLE [dbo].[ObjectProperties]
ADD CONSTRAINT [ObjectProperties_pk] PRIMARY KEY ([ID])

ALTER TABLE [dbo].[ObjectType]
ADD CONSTRAINT [ObjectType_pk] PRIMARY KEY ([ID])

ALTER TABLE [dbo].[ObjectTypeProperties]
ADD CONSTRAINT [ObjectTypeProperties_pk] PRIMARY KEY ([ID])

ALTER TABLE [dbo].[Point]
ADD CONSTRAINT [Point_pk] PRIMARY KEY ([ID])

ALTER TABLE [dbo].[RawImage]
ADD CONSTRAINT [RawImage_pk] PRIMARY KEY ([ID])

ALTER TABLE [dbo].[Right]
ADD CONSTRAINT [Right_pk] PRIMARY KEY ([ID])

ALTER TABLE [dbo].[Scale]
ADD CONSTRAINT [Scale_pk] PRIMARY KEY ([ID])

ALTER TABLE [dbo].[Sign]
ADD CONSTRAINT [Sign_pk] PRIMARY KEY ([ID])

ALTER TABLE [dbo].[Style]
ADD CONSTRAINT [Style_pk] PRIMARY KEY ([ID])

ALTER TABLE [dbo].[User]
ADD CONSTRAINT [User_pk] PRIMARY KEY ([ID])

ALTER TABLE [dbo].[UserGroup]
ADD CONSTRAINT [UserGroup_pk] PRIMARY KEY ([ID])

ALTER TABLE [dbo].[UserRight]
ADD CONSTRAINT [UserRight_pk] PRIMARY KEY ([ID])

-- индексы
CREATE NONCLUSTERED INDEX [BaseMap_BaseMapFile_idx] ON [dbo].[BaseMap_BaseMapFile] ([BaseMapID])

CREATE NONCLUSTERED INDEX [Layer_LayerGroup_idx] ON [dbo].[Layer_LayerGroup] ([LayerGroupID], [DrawOrder])

CREATE NONCLUSTERED INDEX [License_Map_idx] ON [dbo].[License_Map] ([LicenseID])

CREATE NONCLUSTERED INDEX [License_UserGroup_idx] ON [dbo].[License_UserGroup] ([UserGroupID])

CREATE NONCLUSTERED INDEX [Map_BaseMap_idx] ON [dbo].[Map_BaseMap] ([MapID])

CREATE NONCLUSTERED INDEX [Map_LayerGroup_idx] ON [dbo].[Map_LayerGroup] ([MapID], [DrawOrder])

CREATE NONCLUSTERED INDEX [User_UserGroup_idx] ON [dbo].[User_UserGroup] ([UserGroupID])

Эта игра "Угадай ошибку" ?

football07,

У меня данный скрипт выдаёт такую ошибку:

автор
Msg 4902, Level 16, State 1, Line 1 Cannot find the object "dbo.Layer" because it does not exist or you do not have permissions.

Вам для начала нужно сначала создать таблицу dbo.Layer, либо получить на неё разрешения. Я угадал?

Также вот такое:

ALTER TABLE dbo.[Scale]
 ADD [ValueMax] float NULL

update dbo.[Scale]
 set [ValueMax] = 0
 where [ValueMax] is null

— нельзя выполнять в одном батче.

Гость333

football07, У меня данный скрипт выдаёт такую ошибку: автор Msg 4902, Level 16, State 1, Line 1 Cannot find the object "dbo.Layer" because it does not exist or you do not have permissions. Вам для начала нужно сначала создать таблицу dbo.Layer, либо получить на неё разрешения. Я угадал? Также вот такое: ALTER TABLE dbo.[Scale] ADD [ValueMax] float NULL update dbo.[Scale] set [ValueMax] = 0 where [ValueMax] is null — нельзя выполнять в одном батче.

Однако можно прописать DEFAULT(0) и не апдейтить вообще