Tables [dbo].[fun_sqlserver]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CS_AS
HeapYes
Row Count0
Created11:07:15 AM Wednesday, March 07, 2007
Last Modified11:09:38 AM Wednesday, March 07, 2007
Columns
NameData TypeMax Length (Bytes)Allow Nulls
Indexes baseidx_fun_sqlserver: fun_idfun_idint4
No
multi_outint4
No
output_filevarchar(255)255
Yes
write_schemeint4
No
rrobin_countint4
No
rrobin_outputint4
No
filename_patternvarchar(255)255
Yes
listing_filenamevarchar(255)255
Yes
directory_schemeint4
No
use_nfsint4
No
max_output_sizeint4
No
max_output_unitsvarchar(1)1
No
format_typeint4
No
column_delimitervarchar(3)3
Yes
row_delimitervarchar(3)3
Yes
enclosure_charvarchar(3)3
Yes
decimal_pointvarchar(3)3
Yes
fixed_decimalint4
No
date_formatint4
No
long_limitint4
No
format_filevarchar(255)255
Yes
fixed_null_datevarchar(255)255
Yes
log_filevarchar(255)255
Yes
master_device_filevarchar(255)255
Yes
odometerint4
No
sampleint4
No
num_rowsint4
No
max_sort_memint4
No
sql_filevarchar(255)255
Yes
sql_queryvarchar(255)255
Yes
sql_typeint4
No
max_open_filesint4
No
character_setint4
No
all_rowsint4
No
Indexes Indexes
NameColumnsUnique
baseidx_fun_sqlserverfun_id
Yes
Permissions
TypeActionOwning Principal
GrantDeleteudmadmin_group
GrantInsertudmadmin_group
GrantSelectudmadmin_group
GrantUpdateudmadmin_group
SQL Script
CREATE TABLE [dbo].[fun_sqlserver]
(
[fun_id] [int] NOT NULL,
[multi_out] [int] NOT NULL,
[output_file] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[write_scheme] [int] NOT NULL,
[rrobin_count] [int] NOT NULL,
[rrobin_output] [int] NOT NULL,
[filename_pattern] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[listing_filename] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[directory_scheme] [int] NOT NULL,
[use_nfs] [int] NOT NULL,
[max_output_size] [int] NOT NULL,
[max_output_units] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[format_type] [int] NOT NULL,
[column_delimiter] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[row_delimiter] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[enclosure_char] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[decimal_point] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[fixed_decimal] [int] NOT NULL,
[date_format] [int] NOT NULL,
[long_limit] [int] NOT NULL,
[format_file] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[fixed_null_date] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[log_file] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[master_device_file] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[odometer] [int] NOT NULL,
[sample] [int] NOT NULL,
[num_rows] [int] NOT NULL,
[max_sort_mem] [int] NOT NULL,
[sql_file] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[sql_query] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[sql_type] [int] NOT NULL,
[max_open_files] [int] NOT NULL,
[character_set] [int] NOT NULL,
[all_rows] [int] NOT NULL
) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [baseidx_fun_sqlserver] ON [dbo].[fun_sqlserver] ([fun_id]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[fun_sqlserver] TO [udmadmin_group]
GRANT INSERT ON  [dbo].[fun_sqlserver] TO [udmadmin_group]
GRANT DELETE ON  [dbo].[fun_sqlserver] TO [udmadmin_group]
GRANT UPDATE ON  [dbo].[fun_sqlserver] TO [udmadmin_group]
GO
Uses