The metadata is stored in internal tables that you cannot access directly. You can access them through several object management views, including sys.objects, and sys.views for the view itself, sys.columns for the columns defined in a view, and sys.sql_modules for the definition.

Here is one of many possible ways to demonstrate inconsistent results after base table schema changes:

CREATE TABLE dbo.MyTab (IntCol int, CharCol char(1));

INSERT INTO dbo.MyTab (IntCol, CharCol) VALUES(1, 'a');

go

CREATE VIEW dbo.MyView

AS SELECT * FROM MyTab;

go

SELECT * FROM dbo.MyView;

go

ALTER TABLE dbo.MyTab DROP COLUMN IntCol;

ALTER TABLE dbo.MyTab ADD NumCol numeric(5,3);

go

UPDATE dbo.MyTab SET NumCol = 1;

go

SELECT * FROM dbo.MyView;

go

DROP VIEW dbo.MyView;

DROP TABLE dbo.MyTab;

go