[dbo].[tng_popup

Property	Value
Collation	SQL_Latin1_General_CP1_CS_AS
Row Count	411
Created	11:07:35 AM Wednesday, March 07, 2007
Last Modified	5:37:49 PM Monday, May 04, 2009

Property

Value

Collation

SQL_Latin1_General_CP1_CS_AS

Row Count

411

Created

11:07:35 AM Wednesday, March 07, 2007

Last Modified

5:37:49 PM Monday, May 04, 2009

	Name	Data Type	Max Length (Bytes)
$Cluster Primary Key PK__tng_popup_menu__719DA93E: name\sequence_no\label$	name	varchar(40)	40
$Cluster Primary Key PK__tng_popup_menu__719DA93E: name\sequence_no\label$	sequence_no	int	4
$Cluster Primary Key PK__tng_popup_menu__719DA93E: name\sequence_no\label$	label	varchar(40)	40
	method_name	varchar(40)	40
	sub_popup_menu	varchar(40)	40
	bitmap_name	varchar(64)	64
	flag	int	4

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key PK__tng_popup_menu__719DA93E: name\sequence_no\label$

name

varchar(40)

$Cluster Primary Key PK__tng_popup_menu__719DA93E: name\sequence_no\label$

sequence_no

int

$Cluster Primary Key PK__tng_popup_menu__719DA93E: name\sequence_no\label$

label

varchar(40)

method_name

varchar(40)

sub_popup_menu

varchar(40)

bitmap_name

varchar(64)

flag

int

	Name	Columns	Unique
$Cluster Primary Key PK__tng_popup_menu__719DA93E: name\sequence_no\label$	PK__tng_popup_menu__719DA93E	name, sequence_no, label

Name

Columns

Unique

$Cluster Primary Key PK__tng_popup_menu__719DA93E: name\sequence_no\label$

PK__tng_popup_menu__719DA93E

name, sequence_no, label

Type	Action	Owning Principal
Grant	Delete	uniadmin
Grant	Insert	uniadmin
Grant	Delete	wvadmin
Grant	Insert	wvadmin
Grant	Select	uniadmin
Grant	Update	uniadmin
Grant	Select	uniuser
Grant	Select	wvadmin
Grant	Update	wvadmin
Grant	Select	wvuser

Type

Action

Owning Principal

Grant

Delete

uniadmin

Grant

Insert

uniadmin

Grant

Delete

wvadmin

Grant

Insert

wvadmin

Grant

Select

uniadmin

Grant

Update

uniadmin

Grant

Select

uniuser

Grant

Select

wvadmin

Grant

Update

wvadmin

Grant

Select

wvuser

SQL Script

CREATE TABLE [dbo].[tng_popup_menu]
(
[name] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[sequence_no] [int] NOT NULL,
[label] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[method_name] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[sub_popup_menu] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[bitmap_name] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[flag] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[tng_popup_menu] ADD CONSTRAINT [PK__tng_popup_menu__719DA93E] PRIMARY KEY CLUSTERED ([name], [sequence_no], [label]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[tng_popup_menu] TO [uniadmin]
GRANT INSERT ON  [dbo].[tng_popup_menu] TO [uniadmin]
GRANT DELETE ON  [dbo].[tng_popup_menu] TO [uniadmin]
GRANT UPDATE ON  [dbo].[tng_popup_menu] TO [uniadmin]
GRANT SELECT ON  [dbo].[tng_popup_menu] TO [uniuser]
GRANT SELECT ON  [dbo].[tng_popup_menu] TO [wvadmin]
GRANT INSERT ON  [dbo].[tng_popup_menu] TO [wvadmin]
GRANT DELETE ON  [dbo].[tng_popup_menu] TO [wvadmin]
GRANT UPDATE ON  [dbo].[tng_popup_menu] TO [wvadmin]
GRANT SELECT ON  [dbo].[tng_popup_menu] TO [wvuser]
GO