v_DIM_COUNTRY
The Country dimension contains information about countries
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| COUNTRYDIMID | int | BBDW.[DIM_COUNTRY].[COUNTRYDIMID] | |
| COUNTRYSYSTEMID | uniqueidentifier | yes | BBDW.[DIM_COUNTRY].[COUNTRYSYSTEMID] |
| COUNTRY | nvarchar(100) | yes | BBDW.[DIM_COUNTRY].[COUNTRY] |
| COUNTRYABBREVIATION | nvarchar(5) | yes | BBDW.[DIM_COUNTRY].[COUNTRYABBREVIATION] |
Definition
Copy
create view [BBDW].[v_DIM_COUNTRY] as
select
[COUNTRYDIMID],
[COUNTRYSYSTEMID],
[COUNTRY],
[COUNTRYABBREVIATION]
from bbdw.[DIM_COUNTRY]