Definition
CREATE VIEW
[mr].[Source_Type] AS
SELECT
[st].[Source_Type_Id],
[st].[Enum_Key] [Source_Type_Key],
[t].[Translation] [Source_Type],
[st].[Is_Upgradable]
FROM
[dbo].[C_Source_Type] [st]
LEFT JOIN [fw].[Translation] [t] ON [t].[Translation_key] = [st].[Name_Key]
Columns
| # | Column | Data Type | Nullable | Source |
|---|---|---|---|---|
| 1 | Source_Type_Id | smallint | No | C_Source_Type.Source_Type_Id |
| 2 | Source_Type_Key | nvarchar | No | C_Source_Type.Enum_Key |
| 3 | Source_Type | nvarchar | Yes | Translation.TRANSLATION |
| 4 | Is_Upgradable | bit | No | C_Source_Type.Is_Upgradable |
Is Data Source For
| View | Columns |
|---|---|
| Relation | Source_Type |