[dbo].[AMACCMAP]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Heap
Row Count	2
Created	3:44:34 PM Friday, June 13, 2003
Last Modified	3:44:34 PM Friday, June 13, 2003

Property

Value

Collation

SQL_Latin1_General_CP1_CI_AS

Heap

Row Count

Created

3:44:34 PM Friday, June 13, 2003

Last Modified

3:44:34 PM Friday, June 13, 2003

	Name	Data Type	Max Length (Bytes)
$Primary Key AMACCMAP_PK: ACID\DOMAINID$	DOMAINID	int	4
$Primary Key AMACCMAP_PK: ACID\DOMAINID$	ACID	int	4
	ACSRV	varchar(127)	127
	ACNAME	varchar(127)	127
	ACTYPE	int	4
	ACDESC	varchar(127)	127
	ACSTATE	int	4
	ACRIGHTS	text	max

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Primary Key AMACCMAP_PK: ACID\DOMAINID$

DOMAINID

int

$Primary Key AMACCMAP_PK: ACID\DOMAINID$

ACID

int

ACSRV

varchar(127)

127

ACNAME

varchar(127)

127

ACTYPE

int

ACDESC

varchar(127)

127

ACSTATE

int

ACRIGHTS

text

max

	Name	Columns	Unique
$Primary Key AMACCMAP_PK: ACID\DOMAINID$	AMACCMAP_PK	ACID, DOMAINID

Name

Columns

Unique

$Primary Key AMACCMAP_PK: ACID\DOMAINID$

AMACCMAP_PK

ACID, DOMAINID

SQL Script

CREATE TABLE [dbo].[AMACCMAP]
(
[DOMAINID] [int] NOT NULL,
[ACID] [int] NOT NULL,
[ACSRV] [varchar] (127) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ACNAME] [varchar] (127) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ACTYPE] [int] NULL,
[ACDESC] [varchar] (127) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ACSTATE] [int] NULL,
[ACRIGHTS] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[AMACCMAP] ADD CONSTRAINT [AMACCMAP_PK] PRIMARY KEY NONCLUSTERED ([ACID], [DOMAINID]) ON [PRIMARY]
GO