[dbo].[al_next

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	81
Created	10:33:06 PM Thursday, February 10, 2011
Last Modified	10:34:24 PM Thursday, February 10, 2011

Property

Value

Collation

SQL_Latin1_General_CP1_CI_AS

Row Count

Created

10:33:06 PM Thursday, February 10, 2011

Last Modified

10:34:24 PM Thursday, February 10, 2011

	Name	Data Type	Max Length (Bytes)	Default
$Cluster Primary Key xpkal_next_id: table_name\field_name$ $Foreign Keys fk_al_next_id: [dbo].[arg_field_def].table_name\field_name$	table_name	nvarchar(32)	64
$Cluster Primary Key xpkal_next_id: table_name\field_name$ $Foreign Keys fk_al_next_id: [dbo].[arg_field_def].table_name\field_name$	field_name	nvarchar(32)	64
	next_id	bigint	8	('1000000 ')

Name

Data Type

Max Length (Bytes)

Allow Nulls

Default

$Cluster Primary Key xpkal_next_id: table_name\field_name$ $Foreign Keys fk_al_next_id: [dbo].[arg_field_def].table_name\field_name$

table_name

nvarchar(32)

$Cluster Primary Key xpkal_next_id: table_name\field_name$ $Foreign Keys fk_al_next_id: [dbo].[arg_field_def].table_name\field_name$

field_name

nvarchar(32)

next_id

bigint

('1000000 ')

	Name	Columns	Unique
$Cluster Primary Key xpkal_next_id: table_name\field_name$	xpkal_next_id	table_name, field_name

Name

Columns

Unique

$Cluster Primary Key xpkal_next_id: table_name\field_name$

xpkal_next_id

table_name, field_name

Name	Columns
fk_al_next_id	table_name->[dbo].[arg_field_def].[table_name] field_name->[dbo].[arg_field_def].[field_name]

Name

Columns

fk_al_next_id

table_name->[dbo].[arg_field_def].[table_name]
field_name->[dbo].[arg_field_def].[field_name]

SQL Script

CREATE TABLE [dbo].[al_next_id]
(
[table_name] [nvarchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[field_name] [nvarchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[next_id] [bigint] NULL CONSTRAINT [DF__AL_NEXT_ID_NXT_ID_DFLT] DEFAULT ('1000000 ')
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[al_next_id] ADD CONSTRAINT [xpkal_next_id] PRIMARY KEY CLUSTERED ([table_name], [field_name]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[al_next_id] ADD CONSTRAINT [fk_al_next_id] FOREIGN KEY ([table_name], [field_name]) REFERENCES [dbo].[arg_field_def] ([table_name], [field_name])
GO