Table of Contents



pears.ComplianceViewHTML

Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.

Description

Temp Table - Used to construct the Person compliance HTML view.

Columns

Column Type Null Default Comment
InstanceID char(20) NOT NULL
HTMLText long varchar NULL

Primary Key

Foreign Keys

Referenced By

Indexes

Triggers

Original SQL

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."ComplianceViewHTML"
-- Table comment: Temp Table - Used to construct the Person compliance HTML view.
-- Statement count: 2
 
CREATE GLOBAL TEMPORARY TABLE "pears"."ComplianceViewHTML" (
    "InstanceID"                     CHAR(20) NOT NULL
   ,"HTMLText"                       long VARCHAR NULL
   ,PRIMARY KEY ("InstanceID" ASC) 
) ON COMMIT PRESERVE ROWS
GO
 
 
COMMENT ON TABLE "pears"."ComplianceViewHTML" IS 
	'Temp Table - Used to construct the Person compliance HTML view.'
GO