[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	12:32:09 PM Sunday, December 05, 2010
Last Modified	12:32:09 PM Sunday, December 05, 2010

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