
/* Code Fragment 9.3 Reconstruct the PROJECTIONS table as of now, as a view. */

CREATE VIEW PROJECTIONS
	(PROJECTION_ID, PROJECTION_NAME, PROJECTION_TYPE,
	 SPHEROID_CODE, PROJECTION_UOM, ZONE_CODE)
AS
SELECT 	PROJECTION_ID, PROJECTION_NAME, PROJECTION_TYPE,
	SPHEROID_CODE, PROJECTION_UOM, ZONE_CODE
FROM P_TT
WHERE Stop_Date = '9999-12-31'
