Skip to content

Instantly share code, notes, and snippets.

@ChrisRisner

ChrisRisner/CreateView.sql

Created December 18, 2012 17:20
Show Gist options
  • Save ChrisRisner/4329928 to your computer and use it in GitHub Desktop.
Save ChrisRisner/4329928 to your computer and use it in GitHub Desktop.
Download ZIP
existingDBwithViews
Raw
CreateView.sql
USE [existingdb]
GO
/****** Object: View [existingdb].[TodoItem] Script Date: 12/18/2012 9:15:55 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [existingdb].[TodoItem]
AS
SELECT TodoItemID AS id, text, complete
FROM dbo.TodoItem
GO
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment