Tables [dbo].[usm_report_layout]
Properties
PropertyValue
Row Count18
Created11:07:44 AM Wednesday, March 07, 2007
Last Modified1:17:03 PM Tuesday, March 30, 2010
Columns
NameData TypeCollationMax Length (Bytes)Allow Nulls
Cluster Primary Key XPKusm_report_layout: report_layout_idreport_layout_idvarchar(128)SQL_Latin1_General_CP1_CS_AS128
No
commentnvarchar(128)SQL_Latin1_General_CP1_CS_AS256
Yes
data1nvarchar(64)SQL_Latin1_General_CP1_CS_AS128
Yes
data2nvarchar(128)SQL_Latin1_General_CP1_CS_AS256
Yes
data3nvarchar(256)SQL_Latin1_General_CP1_CS_AS512
Yes
time_stampdatetime8
Yes
foldernvarchar(256)SQL_Latin1_General_CP1_CS_AS512
Yes
namenvarchar(256)SQL_Latin1_General_CP1_CS_AS512
Yes
ownernvarchar(128)SQL_Latin1_General_CP1_CS_AS256
Yes
get_variables_pagevarchar(1024)SQL_Latin1_General_CP1_CS_AS1024
Yes
document_stringnvarchar(256)SQL_Latin1_General_CP1_CS_AS512
Yes
external_paramsvarchar(256)SQL_Latin1_General_CP1_CS_AS256
Yes
file_namenvarchar(256)SQL_Latin1_General_CP1_CS_AS512
Yes
typenvarchar(20)SQL_Latin1_General_CP1_CS_AS40
Yes
statusint4
Yes
commentsnvarchar(512)SQL_Latin1_General_CP1_CI_AS1024
Yes
Indexes Indexes
NameColumnsUnique
Cluster Primary Key XPKusm_report_layout: report_layout_idXPKusm_report_layoutreport_layout_id
Yes
Permissions
TypeActionOwning Principal
GrantDeleteusmgroup
GrantInsertusmgroup
GrantSelectusmgroup
GrantUpdateusmgroup
SQL Script
CREATE TABLE [dbo].[usm_report_layout]
(
[report_layout_id] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[comment] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[data1] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[data2] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[data3] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[time_stamp] [datetime] NULL,
[folder] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[name] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[owner] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[get_variables_page] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[document_string] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[external_params] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[file_name] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[type] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[status] [int] NULL,
[comments] [nvarchar] (512) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[usm_report_layout] ADD CONSTRAINT [XPKusm_report_layout] PRIMARY KEY CLUSTERED ([report_layout_id]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[usm_report_layout] TO [usmgroup]
GRANT INSERT ON  [dbo].[usm_report_layout] TO [usmgroup]
GRANT DELETE ON  [dbo].[usm_report_layout] TO [usmgroup]
GRANT UPDATE ON  [dbo].[usm_report_layout] TO [usmgroup]
GO
Uses
Used By