CREATE TABLE [dbo].[HARUSDGROUPNAMES]
(
[GROUPNAME] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[GROUPUUID] [char] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [HARUSDGROUPNAMES_NAME_IND] ON [dbo].[HARUSDGROUPNAMES] ([GROUPNAME]) ON [PRIMARY]
GO
EXEC sp_addextendedproperty N'Caption', N'The HARUSDGROUPNAMES table maintains USD target group names. This information is also synchronized on an interval basis. ', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDGROUPNAMES', NULL, NULL
GO
EXEC sp_addextendedproperty N'Caption', N'The USD group name. For display purposes, the group name has "(Group)" appended to the name.', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDGROUPNAMES', 'COLUMN', N'GROUPNAME'
GO
EXEC sp_addextendedproperty N'Caption', N'The USD UUID of the group', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDGROUPNAMES', 'COLUMN', N'GROUPUUID'
GO
[dbo].[HARUSDGROUPNAMES]
