[dbo].[personview]

(local) > mdb > Views > dbo.personview

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
name
id
fullname
rating
ratingtime
starttime
endtime
createdby
lastupdated
badgeresid
firstname
lastname
department
address
phone
email
title
officeno
dateofhire
source

SQL Script

CREATE VIEW personview as select a.name, b.*, c.screenname as "source" from personalias a, secure_person b, datasource c where a.personid = b.id and a.createdby = c.id

GO

Uses

[dbo].[datasource]
[dbo].[personalias]
[dbo].[secure_person]
dbo