[dbo].[ntfr]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	200
Created	9:08:55 PM Friday, December 05, 2008
Last Modified	4:36:06 PM Wednesday, March 24, 2010

	Name	Data Type	Max Length (Bytes)
	id	int	4
	persid	nvarchar(30)	60
	del	int	4
$Indexes ntfr_X0: sym\tenant$	sym	nvarchar(128)	256
	description	ntext	max
	condition	nvarchar(30)	60
	obj_type	nvarchar(30)	60
	default_rule	int	4
	last_mod_dt	int	4
	last_mod_by	binary(16)	16
	cr_notify_info	nvarchar(30)	60
	chg_notify_info	nvarchar(30)	60
	iss_notify_info	nvarchar(30)	60
	mgs_notify_info	nvarchar(30)	60
	kd_notify_info	nvarchar(30)	60
	kd_comment_notify_info	nvarchar(30)	60
$Indexes ntfr_X0: sym\tenant$	tenant	binary(16)	16
	krc_notify_info	nvarchar(30)	60
	sa_notify_info	nvarchar(30)	60
	cnt_notify_info	nvarchar(30)	60
	ci_notify_info	nvarchar(30)	60

	Name	Columns	Unique
	PK__ntfr__14737ADD	id
	ntfr_X0	sym, tenant
	ntfr_X1	tenant

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

Name	Value
Comment	Added r12

SQL Script

CREATE TABLE [dbo].[ntfr]
(
[id] [int] NOT NULL,
[persid] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[del] [int] NOT NULL,
[sym] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[description] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[condition] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[obj_type] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[default_rule] [int] NULL,
[last_mod_dt] [int] NULL,
[last_mod_by] [binary] (16) NULL,
[cr_notify_info] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[chg_notify_info] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[iss_notify_info] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[mgs_notify_info] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[kd_notify_info] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[kd_comment_notify_info] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[tenant] [binary] (16) NULL,
[krc_notify_info] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[sa_notify_info] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[cnt_notify_info] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ci_notify_info] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[ntfr] ADD CONSTRAINT [PK__ntfr__14737ADD] PRIMARY KEY CLUSTERED ([id]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [ntfr_X0] ON [dbo].[ntfr] ([sym], [tenant]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ntfr_X1] ON [dbo].[ntfr] ([tenant]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[ntfr] TO [service_desk_admin_group]
GRANT INSERT ON  [dbo].[ntfr] TO [service_desk_admin_group]
GRANT DELETE ON  [dbo].[ntfr] TO [service_desk_admin_group]
GRANT UPDATE ON  [dbo].[ntfr] TO [service_desk_admin_group]
GO
EXEC sp_addextendedproperty N'Comment', N'Added r12', 'SCHEMA', N'dbo', 'TABLE', N'ntfr', NULL, NULL
GO