[dbo].[jobview]
(local)
>
mdb
>
Views
> dbo.jobview
Properties
Columns
SQL Script
Uses
Properties
Property
Value
ANSI Nulls On
Quoted Identifier On
Created
11:10:20 AM Wednesday, March 07, 2007
Last Modified
11:10:20 AM Wednesday, March 07, 2007
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