CREATE TABLE [dbo].[ATVariableDefinition] (
    [VariableID] INT           NOT NULL,
    [Name]       NVARCHAR (50) NOT NULL,
    [Scope]      INT           NOT NULL,
    [DataType]   INT           NOT NULL,
    [ProcessID]  INT           NULL,
    [Value]      TEXT          NULL,
    CONSTRAINT [PK_ATVariableDefinition] PRIMARY KEY CLUSTERED ([VariableID] ASC)
);


GO
CREATE NONCLUSTERED INDEX [ScopeandPID]
    ON [dbo].[ATVariableDefinition]([Scope] ASC, [ProcessID] ASC);

