-- =============================================
-- create view basic template
-- =============================================
if exists (select TABLE_NAME
           from INFORMATION_SCHEMA.VIEWS 
           where TABLE_NAME = N'<view_name, sysname, VTSTAuthors>')
    drop view dbo.<view_name, sysname, VTSTAuthors>
go

/******************************************************************************

  dbo.<view_name, sysname, VTSTAuthors>

  purpose     : <purpose_of_view, ,>

  author      : <author_of_view, ,>
  created     : <creation_date, ,>

  history     :
    <creation_date, ,> - <author_of_view, ,> - creation of the view

******************************************************************************/
create view dbo.<view_name, sysname, VTSTAuthors>
as 
    select au_id    as AuthorID
           au_lname as AuthorLastName
           au_fname as AuthorFirstName
    from pubs.dbo.authors
go