CREATE TABLE [dbo].[ClaimDocuments]( > [doc_PK] [uniqueidentifier] NOT NULL, > [doc_desc] [varchar](100) NOT NULL, > [doc_clmfk] [uniqueidentifier] NOT NULL, > [doc_FileGUID] [uniqueidentifier] ROWGUIDCOL NOT NULL, > [doc_file] [varbinary](max) FILESTREAM NOT NULL, > CONSTRAINT [PK_ClaimDocuments] PRIMARY KEY CLUSTERED >( > [doc_PK] ASC >)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] >) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] FILESTREAM_ON [FileStreamGroup1] > >GO>
CREATE TABLE [dbo].[ClaimDocuments]( [doc_PK] [uniqueidentifier] NOT NULL, [doc_desc] [varchar](100) NOT NULL, [doc_clmfk] [uniqueidentifier] NOT NULL, [doc_FileGUID] [uniqueidentifier] ROWGUIDCOL NOT NULL UNIQUE, [doc_file] [varbinary](max) FILESTREAM NOT NULL, CONSTRAINT [PK_ClaimDocuments] PRIMARY KEY CLUSTERED ( [doc_PK] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] FILESTREAM_ON [FileStreamGroup1] GO