[dbo].[lac_job_output]

Tables

[dbo].[lac_job_output]

(local) > mdb > Tables > dbo.lac_job_output

Properties
Columns
Indexes
Permissions
SQL Script
Uses

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

	Name	Data Type	Max Length (Bytes)	Allow Nulls
$Indexes baseidx_lac_job_output: strid\serverid\groupid\jobid\run_num$	strid	decimal(31,0)	17
$Indexes baseidx_lac_job_output: strid\serverid\groupid\jobid\run_num$	serverid	decimal(31,0)	17
$Indexes baseidx_lac_job_output: strid\serverid\groupid\jobid\run_num$	groupid	decimal(31,0)	17
$Indexes baseidx_lac_job_output: strid\serverid\groupid\jobid\run_num$	jobid	decimal(31,0)	17
$Indexes baseidx_lac_job_output: strid\serverid\groupid\jobid\run_num$	run_num	decimal(3,0)	5
	file_name	varchar(255)	255
	file_type	decimal(31,0)	17
	file_location	char(1)	1
	filesize	decimal(31,0)	17

Indexes

Name	Columns
baseidx_lac_job_output	strid, serverid, groupid, jobid, run_num

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

CREATE TABLE [dbo].[lac_job_output]
(
[strid] [decimal] (31, 0) NOT NULL,
[serverid] [decimal] (31, 0) NOT NULL,
[groupid] [decimal] (31, 0) NOT NULL,
[jobid] [decimal] (31, 0) NOT NULL,
[run_num] [decimal] (3, 0) NOT NULL,
[file_name] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[file_type] [decimal] (31, 0) NOT NULL,
[file_location] [char] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[filesize] [decimal] (31, 0) NULL
) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [baseidx_lac_job_output] ON [dbo].[lac_job_output] ([strid], [serverid], [groupid], [jobid], [run_num]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[lac_job_output] TO [udmadmin_group]
GRANT INSERT ON  [dbo].[lac_job_output] TO [udmadmin_group]
GRANT DELETE ON  [dbo].[lac_job_output] TO [udmadmin_group]
GRANT UPDATE ON  [dbo].[lac_job_output] TO [udmadmin_group]
GO

dbo