[dbo].[ap_nm

Property	Value
Collation	SQL_Latin1_General_CP1_CS_AS
Heap
Row Count	0
Created	11:06:59 AM Wednesday, March 07, 2007
Last Modified	11:09:31 AM Wednesday, March 07, 2007

Property

Value

Collation

SQL_Latin1_General_CP1_CS_AS

Heap

Row Count

Created

11:06:59 AM Wednesday, March 07, 2007

Last Modified

11:09:31 AM Wednesday, March 07, 2007

Name	Data Type	Max Length (Bytes)
knm	varchar(32)	32
kkey	int	4
kmax_key	int	4

Name

Data Type

Max Length (Bytes)

Allow Nulls

knm

varchar(32)

kkey

int

kmax_key

int

Name	Columns	Unique
baseidx_ap_nm_key	knm

Name

Columns

Unique

baseidx_ap_nm_key

knm

Type	Action	Owning Principal
Grant	Delete	apnm_admin
Grant	Insert	apnm_admin
Grant	Select	apnm_admin
Grant	Update	apnm_admin
Grant	Select	apnm_user

Type

Action

Owning Principal

Grant

Delete

apnm_admin

Grant

Insert

apnm_admin

Grant

Select

apnm_admin

Grant

Update

apnm_admin

Grant

Select

apnm_user

SQL Script

CREATE TABLE [dbo].[ap_nm_key]
(
[knm] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[kkey] [int] NOT NULL,
[kmax_key] [int] NOT NULL
) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [baseidx_ap_nm_key] ON [dbo].[ap_nm_key] ([knm]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[ap_nm_key] TO [apnm_admin]
GRANT INSERT ON  [dbo].[ap_nm_key] TO [apnm_admin]
GRANT DELETE ON  [dbo].[ap_nm_key] TO [apnm_admin]
GRANT UPDATE ON  [dbo].[ap_nm_key] TO [apnm_admin]
GRANT SELECT ON  [dbo].[ap_nm_key] TO [apnm_user]
GO