CREATE TABLE [dbo].[grpcls_groups]
(
[clsg_group_code] [dbo].[ais_code_short] NOT NULL,
[clsg_l1] [nvarchar] (64) COLLATE French_CI_AS NOT NULL,
[clsg_l2] [nvarchar] (64) COLLATE French_CI_AS NULL,
[clsg_l3] [nvarchar] (64) COLLATE French_CI_AS NULL
) ON [PRIMARY]
ALTER TABLE [dbo].[grpcls_groups] ADD
CONSTRAINT [CK__grpcls_groups_clsg_group_code__string_pk] CHECK ((len(ltrim(rtrim([clsg_group_code])))>(0) AND charindex('*',[clsg_group_code])=(0) AND charindex('%',[clsg_group_code])=(0)))
GO
ALTER TABLE [dbo].[grpcls_groups] ADD CONSTRAINT [PK_grpcls_groups] PRIMARY KEY CLUSTERED  ([clsg_group_code]) ON [PRIMARY]
GO
