CREATE TABLE [dbo].[ais_t]
(
[aist_test] [dbo].[ais_code_short] NOT NULL,
[aist_cur] [dbo].[ais_decimal2] NULL,
[aist_dec2] [dbo].[ais_decimal2] NULL,
[aist_dec4] [dbo].[ais_decimal4] NULL,
[aist_int] [int] NULL,
[aist_int2] [int] NULL,
[aist_prc] [dbo].[ais_decimal4] NULL,
[aist_date] [date] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ais_t] ADD CONSTRAINT [CK__ais_t_aist_test__string_pk] CHECK ((len(ltrim(rtrim([aist_test])))>(0) AND charindex('*',[aist_test])=(0) AND charindex('%',[aist_test])=(0)))
GO
ALTER TABLE [dbo].[ais_t] ADD CONSTRAINT [PK_ais_t] PRIMARY KEY CLUSTERED  ([aist_test]) ON [PRIMARY]
GO
