Views [dbo].[al_bi_platform_view]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnNo
Created7:00:37 PM Tuesday, April 26, 2011
Last Modified7:00:37 PM Tuesday, April 26, 2011
Columns
Name
PLATFORM_UUID
INACTIVE
NAME
DESCRIPTION
CREATION_USER
CREATION_DATE
LAST_UPDATE_USER
LAST_UPDATE_DATE
VERSION_NUMBER
SOURCE_TYPE_ID
SQL Script
SET QUOTED_IDENTIFIER OFF
GO
CREATE VIEW al_bi_platform_view
AS
SELECT     PLATFORM_UUID, INACTIVE, NAME, DESCRIPTION, CREATION_USER, CONVERT(varchar, dbo.SECS2DATE(CREATION_DATE), 101) AS CREATION_DATE,
                      LAST_UPDATE_USER, CONVERT(varchar, dbo.SECS2DATE(LAST_UPDATE_DATE), 101) AS LAST_UPDATE_DATE, VERSION_NUMBER, SOURCE_TYPE_ID
FROM         AL_PLATFORM
GO
Uses