[dbo].[e2e_wrm_columnnamev]

(local) > mdb > Views > dbo.e2e_wrm_columnnamev

Properties
Columns
Permissions
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On
Created	11:10:13 AM Wednesday, March 07, 2007
Last Modified	11:10:13 AM Wednesday, March 07, 2007

Columns

Name
columnname
title
tablename
reporttitle
isvisible
presentation
formula
sortby

Permissions

Type	Action	Owning Principal
Grant	Select	apmadmin

SQL Script

create view  e2e_wrm_columnnamev AS
SELECT e2e_wrm_reportcolumn.columnname, e2e_wrm_reportcolumn.title,
e2e_wrm_report.tablename, e2e_wrm_report.title AS reporttitle,
e2e_wrm_reportcolumn.isvisible, e2e_wrm_reportcolumn.presentation,
e2e_wrm_reportcolumn.formula, e2e_wrm_reportcolumn.sortby
FROM  e2e_wrm_report inner JOIN  e2e_wrm_reportcolumn
ON e2e_wrm_report.reportid = e2e_wrm_reportcolumn.reportid

GO
GRANT SELECT ON  [dbo].[e2e_wrm_columnnamev] TO [apmadmin]
GO

Uses

[dbo].[e2e_wrm_report]
[dbo].[e2e_wrm_reportcolumn]
dbo