[dbo].[jobview]
(local)
>
mdb
>
Views
> dbo.jobview
Properties
Columns
SQL Script
Uses
Properties
Property
Value
ANSI Nulls On
Quoted Identifier On
Created
12:32:10 PM Sunday, December 05, 2010
Last Modified
12:32:10 PM Sunday, December 05, 2010
Columns
Name
name
starttime
repeats
delay
state
SQL Script
CREATE
VIEW
"jobview"
(
"name"
,
"starttime"
,
"repeats"
,
"delay"
,
"state"
)
AS
SELECT
"secure_job"
.
"name"
,
dbo.varchar
(
secure_job.start_time
),
"secure_job"
.
"repeats"
,
dbo.varchar
(
secure_job.delay
),
"secure_job"
.
"state"
FROM
"secure_job"
GO
Uses
[dbo].[secure_job]
[dbo].[varchar]
dbo