[dbo].[al_bi_language

[dbo].[al_bi_language_view]

(local) > mdb > Views > dbo.al_bi_language_view

Properties
Columns
SQL Script
Uses

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

Columns

Name
lang_code
lang_name
creation_user
creation_date
last_update_user
last_update_date
language_uuid
inactive
version_number
source_type_id
tenant

SQL Script

CREATE VIEW [dbo].[al_bi_language_view]
AS
SELECT     lang_code, lang_name, creation_user, CONVERT(varchar, dbo.SECS2DATE(creation_date), 101) AS creation_date, last_update_user, last_update_date,
                      language_uuid, [inactive ], version_number, source_type_id, tenant
FROM         dbo.ca_language
GO

Uses

[dbo].[ca_language]
[dbo].[secs2date]
[dbo].[varchar]
dbo