[dbo].[HARUSDCOMPUTERNAMES]
CREATE TABLE [dbo].[HARUSDCOMPUTERNAMES]
(
[COMPUTERNAME] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[COMPUTERUUID] [char] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [HARUSDCOMPUTERNAMES_NAME_IND] ON [dbo].[HARUSDCOMPUTERNAMES] ([COMPUTERNAME]) ON [PRIMARY]
GO
EXEC sp_addextendedproperty N'Caption', N'The HARUSDCOMPUTERNAMES table maintains USD target computer names. It is updated periodically by an HServer based on an HBroker.arg parameter that specifies at what interval the information is to be resynchronized. ', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDCOMPUTERNAMES', NULL, NULL
GO
EXEC sp_addextendedproperty N'Caption', N'The computer name of the target.', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDCOMPUTERNAMES', 'COLUMN', N'COMPUTERNAME'
GO
EXEC sp_addextendedproperty N'Caption', N'The USD UUID of the target', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDCOMPUTERNAMES', 'COLUMN', N'COMPUTERUUID'
GO
