SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[view_name_view]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [dbo].[view_name_view]
GO
create view dbo.view_name_view
as
/***************************************************************************
* Comment block
* (view name)
*
* (view summary)
*
*
* Change history
* ****************
* Update:
* by:
* On:
*
***************************************************************************
*/
(select statement)
go
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO