[dbo].[machineview]

(local) > mdb > Views > dbo.machineview

Properties
Columns
SQL Script
Uses

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
id
screenname
description
buildingid
coord_x
coord_y
coord_z
floor
class
rating
ratingtime
starttime
endtime
createdby
lastupdated
building
name
source

SQL Script

CREATE VIEW machineview as select a.*, b.screenname as "building", c.name, d.screenname as "source" from secure_machine a, building b, machinealias c, datasource d where c.machineid = a.id and a.buildingid = b.id and c.createdby = d.id

GO

Uses

[dbo].[building]
[dbo].[datasource]
[dbo].[machinealias]
[dbo].[secure_machine]
dbo