vwALLSYMPTOMS

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

CASite

varchar

null

SYM_ID

int

null

SYM_DESC

varchar

200

null

View Definition

CREATE View vwALLSYMPTOMS
AS

SELECT 'Brain' as CASite, SYM_ID, SYM_DESC FROM ltblSYMPTOMS_BRAIN
	UNION
	SELECT 'Breast' as CASite, SYM_ID, SYM_DESC FROM ltblSYMPTOMS_BREAST
	UNION
	SELECT 'Colorectal' as CASite, SYM_ID, SYM_DESC FROM ltblSYMPTOMS_COLORECTAL
	UNION
	SELECT 'Gynaecology' as CASite, SYM_ID, SYM_DESC FROM ltblSYMPTOMS_GYNAECOLOGY
	UNION
	SELECT 'Haematology' as CASite, SYM_ID, SYM_DESC FROM ltblSYMPTOMS_HAEMATOLOGY
	UNION
	SELECT 'Head and Neck' as CASite, SYM_ID, SYM_DESC FROM ltblSYMPTOMS_HEAD_NECK
	UNION
	SELECT 'Lung' as CASite, SYM_ID, SYM_DESC FROM ltblSYMPTOMS_LUNG
	UNION
	SELECT 'Paediatric' as CASite, SYM_ID, SYM_DESC FROM ltblSYMPTOMS_PAEDIATRIC
	UNION
	SELECT 'Sarcoma' as CASite, SYM_ID, SYM_DESC FROM ltblSYMPTOMS_SARCOMA
	UNION
	SELECT 'Skin' as CASite, SYM_ID, SYM_DESC FROM ltblSYMPTOMS_DERMATOLOGY
	UNION
	SELECT 'Upper GI' as CASite, SYM_ID, SYM_DESC FROM ltblSYMPTOMS_UPPER_GI
	UNION
	SELECT 'Urology' as CASite, SYM_ID, SYM_DESC FROM ltblSYMPTOMS_UROLOGY

Columns

View Definition

Possibly Referenced Tables/Views