Views [dbo].[al_bi_res_os_view]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Created10:33:18 PM Thursday, February 10, 2011
Last Modified10:33:18 PM Thursday, February 10, 2011
Columns
Name
id
inactive
name
description
creation_user
creation_date
last_update_user
last_update_date
version_number
exclude_registration
delete_time
authoritative
tenant
TENANT_DISPLAY
SQL Script
CREATE VIEW [dbo].[al_bi_res_os_view]
AS
SELECT     id, inactive, name, description, creation_user, creation_date, last_update_user, last_update_date, version_number, exclude_registration, delete_time,
                      authoritative, tenant,dbo.al_bi_bintohexstr(tenant) AS TENANT_DISPLAY
FROM         dbo.ca_resource_operating_system
GO
Uses