[dbo].[RM00102]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count (~)	1
Created	4:57:08 PM Thursday, September 7, 2006
Last Modified	11:13:37 AM Monday, August 19, 2013

	Name	Data Type	Max Length (Bytes)	Identity
$Cluster Primary Key PK_RM00102: CUSTNMBR\ADRSCODE$	CUSTNMBR	char(15)	15
$Cluster Primary Key PK_RM00102: CUSTNMBR\ADRSCODE$	ADRSCODE	char(15)	15
	SLPRSNID	char(15)	15
	UPSZONE	char(3)	3
	SHIPMTHD	char(15)	15
	TAXSCHID	char(15)	15
	CNTCPRSN	char(61)	61
	ADDRESS1	char(61)	61
	ADDRESS2	char(61)	61
	ADDRESS3	char(61)	61
	COUNTRY	char(61)	61
	CITY	char(35)	35
	STATE	char(29)	29
	ZIP	char(11)	11
	PHONE1	char(21)	21
	PHONE2	char(21)	21
	PHONE3	char(21)	21
	FAX	char(21)	21
	MODIFDT	datetime	8
	CREATDDT	datetime	8
	DEX_ROW_ID	int	4	1 - 1

	Name	Columns	Unique	Fill Factor
$Cluster Primary Key PK_RM00102: CUSTNMBR\ADRSCODE$	PK_RM00102	CUSTNMBR, ADRSCODE		80

Name	On Column	Constraint
CK_RM00102_CREATDDT	CREATDDT	(datepart(hour,[CREATDDT])=(0) AND datepart(minute,[CREATDDT])=(0) AND datepart(second,[CREATDDT])=(0) AND datepart(millisecond,[CREATDDT])=(0))
CK_RM00102_MODIFDT	MODIFDT	(datepart(hour,[MODIFDT])=(0) AND datepart(minute,[MODIFDT])=(0) AND datepart(second,[MODIFDT])=(0) AND datepart(millisecond,[MODIFDT])=(0))

Type	Action	Owning Principal
Grant	Delete	MssExec
Grant	Insert	MssExec
Grant	Select	MssExec
Grant	Update	MssExec

SQL Script

CREATE TABLE [dbo].[RM00102]
(
[CUSTNMBR] [char] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ADRSCODE] [char] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[SLPRSNID] [char] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[UPSZONE] [char] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[SHIPMTHD] [char] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[TAXSCHID] [char] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CNTCPRSN] [char] (61) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ADDRESS1] [char] (61) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ADDRESS2] [char] (61) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ADDRESS3] [char] (61) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[COUNTRY] [char] (61) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CITY] [char] (35) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[STATE] [char] (29) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ZIP] [char] (11) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[PHONE1] [char] (21) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[PHONE2] [char] (21) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[PHONE3] [char] (21) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[FAX] [char] (21) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[MODIFDT] [datetime] NOT NULL,
[CREATDDT] [datetime] NOT NULL,
[DEX_ROW_ID] [int] NOT NULL IDENTITY(1, 1)
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[RM00102] ADD CONSTRAINT [CK_RM00102_CREATDDT] CHECK ((datepart(hour,[CREATDDT])=(0) AND datepart(minute,[CREATDDT])=(0) AND datepart(second,[CREATDDT])=(0) AND datepart(millisecond,[CREATDDT])=(0)))
GO
ALTER TABLE [dbo].[RM00102] ADD CONSTRAINT [CK_RM00102_MODIFDT] CHECK ((datepart(hour,[MODIFDT])=(0) AND datepart(minute,[MODIFDT])=(0) AND datepart(second,[MODIFDT])=(0) AND datepart(millisecond,[MODIFDT])=(0)))
GO
ALTER TABLE [dbo].[RM00102] ADD CONSTRAINT [PK_RM00102] PRIMARY KEY CLUSTERED  ([CUSTNMBR], [ADRSCODE]) WITH (FILLFACTOR=80) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[RM00102] TO [MssExec]
GRANT INSERT ON  [dbo].[RM00102] TO [MssExec]
GRANT DELETE ON  [dbo].[RM00102] TO [MssExec]
GRANT UPDATE ON  [dbo].[RM00102] TO [MssExec]
GO