19 lines
326 B
Transact-SQL
19 lines
326 B
Transact-SQL
USE [EnVisage]
|
|
GO
|
|
|
|
ALTER VIEW [dbo].[BLL_Objects] AS
|
|
SELECT Id, 'Company' AS EntityName FROM Company
|
|
UNION ALL
|
|
SELECT Id, 'View' FROM [View]
|
|
UNION ALL
|
|
SELECT Id, 'Team' FROM Team
|
|
UNION ALL
|
|
SELECT Id, 'Resource' FROM PeopleResource
|
|
UNION ALL
|
|
SELECT Id, 'Scenario' FROM Scenario
|
|
UNION ALL
|
|
SELECT Id, 'Project' FROM Project
|
|
GO
|
|
|
|
|