1. Создаем копию таблицы RG405 в Х_RG405
CREATE TABLE [Х_RG405] (
	[PERIOD] [datetime] NOT NULL ,
	[SP4062] [char] (9) COLLATE Cyrillic_General_CI_AS NOT NULL ,
	[SP408] [char] (9) COLLATE Cyrillic_General_CI_AS NOT NULL ,
	[SP418] [char] (9) COLLATE Cyrillic_General_CI_AS NOT NULL ,
	[SP3117] [numeric](14, 2) NOT NULL ,
	[SP411] [numeric](14, 5) NOT NULL ,
	CONSTRAINT [PK_Х_RG405] PRIMARY KEY  CLUSTERED 
	(
		[PERIOD],
		[SP4062],
		[SP408],
		[SP418],
		[SP3117]
	)  ON [PRIMARY] 
) ON [PRIMARY]


2. Копируем данные из  RG405 в  Х_RG405
insert into  Х_RG405
 select * from rg405


3. Удаляем таблицу RG405
drop index rg405.VIA408
drop table rg405


4.Создаем RG405 с полем PERIOD имеет тип   smalldatetime
CREATE TABLE [RG405] (
	[PERIOD] [smalldatetime] NOT NULL ,
	[SP4062] [char] (9) COLLATE Cyrillic_General_CI_AS NOT NULL ,
	[SP408] [char] (9) COLLATE Cyrillic_General_CI_AS NOT NULL ,
	[SP418] [char] (9) COLLATE Cyrillic_General_CI_AS NOT NULL ,
	[SP3117] [numeric](14, 2) NOT NULL ,
	[SP411] [numeric](14, 5) NOT NULL ,
	CONSTRAINT [PK_RG405] PRIMARY KEY  CLUSTERED 
	(
		[PERIOD],
		[SP4062],
		[SP408],
		[SP418],
		[SP3117]
	)  ON [PRIMARY] 
) ON [PRIMARY]

5. Копируем данные из  Х_RG405 в  Х_RG405

insert into  RG405
 select * from Х_rg405

6. Создаем индекс VIA408 в таблице RG405
create index VIA408 ON  rg405(PERIOD, SP408)

7. Удаляем таблицу Х_RG405
drop table Х_rg405