[dbo].[al_bi_tenant_grp

[dbo].[al_bi_tenant_grp_view]

(local) > mdb > Views > dbo.al_bi_tenant_grp_view

Properties
Columns
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On
Created	10:33:18 PM Thursday, February 10, 2011
Last Modified	10:33:18 PM Thursday, February 10, 2011

Columns

Name
id
id_display
name
description
inactive
version_number
creation_user
creation_date
last_update_user
last_update_date
readonly
auto_rep_version

SQL Script

CREATE VIEW [dbo].[al_bi_tenant_grp_view]
AS
SELECT     id,dbo.al_bi_bintohexstr(id) AS id_display, name, description, inactive, version_number, creation_user, creation_date, last_update_user, last_update_date,
                      readonly, auto_rep_version
FROM         dbo.ca_tenant_group
GO

Uses

[dbo].[ca_tenant_group]
[dbo].[al_bi_bintohexstr]
dbo