if exists (select * from dbo.sysobjects where id = object_id(N'[EML3774]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table EML3774
GO

CREATE TABLE  [EML3774]
(

[IdEML3774] [int] IDENTITY (1, 1) NOT NULL, 
[IdEML3773] [int] NOT NULL, 
[FromMailsAndNames] [varchar] (512) COLLATE Cyrillic_General_CI_AS  NULL,
[ToName] [varchar] (120) COLLATE Cyrillic_General_CI_AS  NULL,
[ToCopyMailsAndNames] [varchar] (512) COLLATE Cyrillic_General_CI_AS  NULL,
[Name] [varchar] (512) COLLATE Cyrillic_General_CI_AS  NULL,
[IdEML3772] [int]  NULL,
[FileRef] [image]  NULL,
[Dsc] [varchar] (6200) COLLATE Cyrillic_General_CI_AS  NULL,
[DateIns] [datetime] NOT NULL, 
[DateUpd] [datetime]  NULL,
[DateDel] [datetime]  NULL,
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[EML3774] ADD CONSTRAINT [DF__EML3774_Ma__DateI] DEFAULT (getdate()) FOR [DateIns]
ALTER TABLE [dbo].[EML3774] ADD CONSTRAINT [EML3774_PK] PRIMARY KEY  NONCLUSTERED 
(
[IdEML3774]
) ON [PRIMARY]
GO
CREATE  INDEX [EML3774_DateDel_I] ON [dbo].[EML3774] ([DateDel]) ON [PRIMARY]
GO
CREATE  INDEX [EML3774_IdEML3773_I] ON [dbo].[EML3774] ([IdEML3773]) ON [PRIMARY]
GO
CREATE  INDEX [EML3774_IdEML3772_I] ON [dbo].[EML3774] ([IdEML3772]) ON [PRIMARY]
GO