CREATE VIEW dbo.Authors_Indexed_View WITH SCHEMABINDING AS SELECT au_id, au_lname, au_fname, phone, address, CONVERT(char(20), ' ') AS address1, city, state, zip, contract FROM dbo.authors GO CREATE UNIQUE CLUSTERED INDEX [IX_Authors_Indexed_View] ON [dbo].[Authors_Indexed_View]([au_id]) ON [PRIMARY] GO