CREATE TABLE [dbo].[nm_reference_database_objects]
(
[nrdo_SchemaName] [varchar] (128) COLLATE French_CI_AS NOT NULL,
[nrdo_ObjectName] [varchar] (128) COLLATE French_CI_AS NOT NULL,
[nrdo_ObjectType] [varchar] (2) COLLATE French_CI_AS NOT NULL,
[nrdo_ObjectTypeDescription] [varchar] (60) COLLATE French_CI_AS NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[nm_reference_database_objects] ADD CONSTRAINT [CK__nm_reference_database_objects_nrdo_ObjectName__string_pk] CHECK ((len(ltrim(rtrim([nrdo_ObjectName])))>(0) AND charindex('*',[nrdo_ObjectName])=(0) AND charindex('%',[nrdo_ObjectName])=(0)))
GO
ALTER TABLE [dbo].[nm_reference_database_objects] ADD CONSTRAINT [CK__nm_reference_database_objects_nrdo_SchemaName__string_pk] CHECK ((len(ltrim(rtrim([nrdo_SchemaName])))>(0) AND charindex('*',[nrdo_SchemaName])=(0) AND charindex('%',[nrdo_SchemaName])=(0)))
GO
ALTER TABLE [dbo].[nm_reference_database_objects] ADD CONSTRAINT [PK_nm_reference_database_objects] PRIMARY KEY CLUSTERED ([nrdo_SchemaName], [nrdo_ObjectName]) ON [PRIMARY]
GO
