[dbo].[usm_report_profile

Property	Value
Row Count	0
Created	12:31:34 PM Sunday, December 05, 2010
Last Modified	5:02:32 PM Monday, April 25, 2011

Property

Value

Row Count

Created

12:31:34 PM Sunday, December 05, 2010

Last Modified

5:02:32 PM Monday, April 25, 2011

	Name	Data Type	Collation	Max Length (Bytes)
$Cluster Primary Key XPKusm_report_profile_spec: attribute_name\section$	attribute_name	varchar(50)	SQL_Latin1_General_CP1_CS_AS	50
$Cluster Primary Key XPKusm_report_profile_spec: attribute_name\section$	section	varchar(50)	SQL_Latin1_General_CP1_CS_AS	50
	default_value	nvarchar(2048)	SQL_Latin1_General_CP1_CI_AS	4096
	label	nvarchar(255)	SQL_Latin1_General_CP1_CS_AS	510
	label_bundle_key	varchar(50)	SQL_Latin1_General_CP1_CS_AS	50
	help	nvarchar(255)	SQL_Latin1_General_CP1_CS_AS	510
	help_bundle_key	varchar(50)	SQL_Latin1_General_CP1_CS_AS	50
	type	varchar(50)	SQL_Latin1_General_CP1_CS_AS	50
	tab_order	int		4

Name

Data Type

Collation

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key XPKusm_report_profile_spec: attribute_name\section$

attribute_name

varchar(50)

SQL_Latin1_General_CP1_CS_AS

$Cluster Primary Key XPKusm_report_profile_spec: attribute_name\section$

section

varchar(50)

SQL_Latin1_General_CP1_CS_AS

default_value

nvarchar(2048)

SQL_Latin1_General_CP1_CI_AS

4096

label

nvarchar(255)

SQL_Latin1_General_CP1_CS_AS

510

label_bundle_key

varchar(50)

SQL_Latin1_General_CP1_CS_AS

help

nvarchar(255)

SQL_Latin1_General_CP1_CS_AS

510

help_bundle_key

varchar(50)

SQL_Latin1_General_CP1_CS_AS

type

varchar(50)

SQL_Latin1_General_CP1_CS_AS

tab_order

int

	Name	Columns	Unique
$Cluster Primary Key XPKusm_report_profile_spec: attribute_name\section$	XPKusm_report_profile_spec	attribute_name, section

Name

Columns

Unique

$Cluster Primary Key XPKusm_report_profile_spec: attribute_name\section$

XPKusm_report_profile_spec

attribute_name, section

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

Type

Action

Owning Principal

Grant

Delete

usmgroup

Grant

Insert

usmgroup

Grant

Select

usmgroup

Grant

Update

usmgroup

SQL Script

CREATE TABLE [dbo].[usm_report_profile_spec]
(
[attribute_name] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[section] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[default_value] [nvarchar] (2048) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[label] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[label_bundle_key] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[help] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[help_bundle_key] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[type] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[tab_order] [int] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[usm_report_profile_spec] ADD CONSTRAINT [XPKusm_report_profile_spec] PRIMARY KEY CLUSTERED ([attribute_name], [section]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[usm_report_profile_spec] TO [usmgroup]
GRANT INSERT ON  [dbo].[usm_report_profile_spec] TO [usmgroup]
GRANT DELETE ON  [dbo].[usm_report_profile_spec] TO [usmgroup]
GRANT UPDATE ON  [dbo].[usm_report_profile_spec] TO [usmgroup]
GO