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.
/****** Object: View [dbo].[tspvGPNotes] Script Date: 06/17/2010 15:11:40 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE VIEW [dbo].[tspvGPNotes1]
SELECT * FROM sy03900