SQL View – GP Notes

The following view just pulls the raw table data out of the SY03900 (notes) table and gives it a friendly name.  It just helps me when I can’t remember what table the notes are stored in .

You can name the view whatever you want by changing the [tspvGPNotes] below.  Also the USE [TSP] tells the script to only execute on my database named TSP.  You will need to modify the [TSP] to be whatever your database name is.

USE [TSP]
GO
/****** Object:  View [dbo].[tspvGPNotes]    Script Date: 06/17/2010 15:11:40 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[tspvGPNotes1]
AS
SELECT * FROM sy03900