CREATE TABLE [dbo].[arg_table_def]
(
[table_name] [nvarchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[table_description] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[database_name] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[subschema_name] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[extended] [smallint] NULL,
[virtual_table] [smallint] NULL,
[inactive] [smallint] NULL,
[creation_user] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[creation_date] [int] NULL,
[last_update_user] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[last_update_date] [int] NULL,
[version_number] [int] NULL CONSTRAINT [DF__arg_table__versi__0169315C] DEFAULT ('0'),
[core] [int] NOT NULL CONSTRAINT [DF__ARG_TABLE___CORE__21A0F6C4] DEFAULT ('1'),
[cora_next_id] [int] NULL CONSTRAINT [DF__ARG_TABLE__CORA___22951AFD] DEFAULT ('0'),
[audit_table] [nvarchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[al_next_id] [int] NOT NULL CONSTRAINT [DF__TABLE_DEF_ALNEXTID_DFLT] DEFAULT ('0')
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[arg_table_def] ADD CONSTRAINT [XPKarg_table_def] PRIMARY KEY CLUSTERED ([table_name]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[arg_table_def] ADD CONSTRAINT [table_def_audit_table_fk] FOREIGN KEY ([audit_table]) REFERENCES [dbo].[arg_table_def] ([table_name])
GO
GRANT SELECT ON [dbo].[arg_table_def] TO [swcmadmin]
GRANT INSERT ON [dbo].[arg_table_def] TO [swcmadmin]
GRANT DELETE ON [dbo].[arg_table_def] TO [swcmadmin]
GRANT UPDATE ON [dbo].[arg_table_def] TO [swcmadmin]
GO