CREATE TABLE [dbo].[md_strings]
(
[str_string_name] [dbo].[ais_name] NOT NULL,
[str_l1] [nvarchar] (255) COLLATE French_CI_AS NOT NULL,
[str_l2] [nvarchar] (255) COLLATE French_CI_AS NULL,
[str_l3] [nvarchar] (255) COLLATE French_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[md_strings] ADD CONSTRAINT [CK__md_strings_str_string_name__string_pk] CHECK ((len(ltrim(rtrim([str_string_name])))>(0) AND charindex('*',[str_string_name])=(0) AND charindex('%',[str_string_name])=(0)))
GO
ALTER TABLE [dbo].[md_strings] ADD CONSTRAINT [PK_md_strings] PRIMARY KEY CLUSTERED  ([str_string_name]) ON [PRIMARY]
GO
