[dbo].[machineview]

(local) > mdb > Views > dbo.machineview

Properties
Columns
SQL Script
Uses

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
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