Definition

CREATE   VIEW
  [fw].[Translation] AS
SELECT
  t.[Translation_Id],
  t.[Text_Value] TRANSLATION,
  tk.[Key_Id] Translation_Key_Id,
  tk.[Key_Name] Translation_Key,
  l.[Language_Code]
FROM
  dbo.[C_Translation] t
  JOIN [dbo].[C_Translation_Key] tk  ON [tk].[Key_Id] = [t].[Key_Id]
  JOIN [dbo].[C_Language] l  ON [l].[Language_Id] = [t].[Language_Id]
  JOIN [repl].[Configuration] c ON c.[Configuration_Value] = l.[Language_Code]
COLLATE SQL_Latin1_General_CP1_CI_AS
AND c.[Configuration_Key] = 'default_language'

Columns

#ColumnData TypeNullableSource
1Translation_IdintNoC_Translation.Translation_Id
2TRANSLATIONnvarcharYesC_Translation.Text_Value
3Translation_Key_IdintNo
4Translation_KeyvarcharNoC_Translation_Key.Key_Name
5Language_CodenvarcharNoC_Language.Language_Code

Is Data Source For

ViewColumns
ApplicationTRANSLATION
Attribute_TypeTRANSLATION
Object_StateTRANSLATION
Object_TypeTRANSLATION
Relation_TypeTRANSLATION
Source_TypeTRANSLATION
Workflow_StateTRANSLATION