Listing 3: Code for Example 3

CREATE VIEW [dbo].[uvwMyBottomView]
AS
  SELECT '1' AS [Column1]
GO
CREATE VIEW [dbo].[uvwMyTopView]
AS
  SELECT * FROM [dbo].[uvwMyBottomView]
GO
DROP VIEW [dbo].[uvwMyBottomView]
GO