View (object)

Specifies a SQL query that is stored in the database under an assigned name. The result of the view query is a virtual table.

Valid Owning Object Types

Name DBMS Brands/Versions
ModelAccess 9.0+, DB2 for LUW 8.1+, DB2 for z/OS 6.0+, Informix 7.0+, Ingres 2.5+, ODBC 2.0+, Oracle 8.0+, Progress 8.0+, Red Brick 5.0+, SAS 1.0+, SQL Server 7.0+, Sybase 12.5+, Teradata 2.0+, DB2 for i 4.0+, Sybase IQ 12.5+, MySQL 5.0+, SQL Azure 10.0+

Valid Owned Object Types

Name DBMS Brands/Versions
AttributeAll
Extended_NotesAll
Key_GroupOracle 9.0+, SQL Server 9.0+, SQL Azure 10.0+
LockTeradata 2.6+
PermissionDB2 for LUW 9.1+, DB2 for z/OS 8.1+, SQL Server 9.0+, Teradata 2.5+, SQL Azure 10.0+
SynonymDB2 for LUW 9.1+, DB2 for z/OS 2.0+, Oracle 9.0+
TriggerDB2 for LUW 9.1+, DB2 for z/OS 9.1+, Informix 6.0+, Ingres 1.0+, Oracle 9.0+, SQL Server 9.0+, Sybase 4.0+, SQL Azure 10.0+

Tagged Values

Name Value
Long_Id{E7AB3CC0-47AD-4A10-8972-C0FB869EE7CB}+40200053
tag_Display_Name_ResourceView
tag_Display_Name_Resource_PluralViews
tag_Is_Abstractfalse
tag_Is_Logicalfalse
tag_Is_Physicaltrue
tag_Legacy_Ownership_Depth0
tag_Physical_Name_TextView
tag_Release_Added7.2.0

Valid Property Types

Name DBMS Brands/Versions
Allow_Row_MovementDB2 for LUW 9.1+
Built_In_IdAll
Child_Relationships_RefAll
Common_Table_ExpressionDB2 for LUW 9.1+, DB2 for z/OS 8.1+
Database_IdDB2 for LUW 9.1+, DB2 for z/OS 8.1+
Database_Internal_NameAll
DefinitionAll
Dependent_Objects_RefAll
Do_Not_GenerateAll
Drawing_Objects_RefAll
Force_CreateOracle 8.0+
Functions_RefDB2 for LUW 9.1+, DB2 for z/OS 8.1+, Oracle 9.0+, SQL Server 9.0+, Teradata 2.6+, SQL Azure 10.0+
Group_By_ClauseAll
Having_ClauseAll
Hide_In_LogicalAll
Hide_In_PhysicalAll
Hierarchical_ConditionOracle 8.1+
History_ListAll
Icon_Image_RefAll
Is_Query_Optimization_DisabledDB2 for LUW 9.1+
LabelAccess 1.0+, DB2 for z/OS 8.1+, Progress 8.0+, DB2 for i 4.0+
Long_IdAll
Macros_RefTeradata 2.6+
ModeAll
NameAll
Name_QualifierAll
No_CycleOracle 8.1+
Note_ListAll
Object_GUIDAll
Oracle_ConstraintOracle 8.0+
Order_By_ClauseAll
Owner_PathAll
Parent_Relationships_RefAll
Physical_Columns_Order_RefAll
Qualify_ClauseTeradata 2.6+
Restriction_TypeAll
SQLAll
SQLServer_Is_ObfuscatedSQL Server 9.0+
SQLServer_Return_View_MetadataSQL Server 9.0+, SQL Azure 10.0+
SQLServer_Use_Schema_BindingSQL Server 9.0+, SQL Azure 10.0+
Schema_NameAccess 9.0+, DB2 for LUW 8.1-8.1, DB2 for z/OS 6.0-8.0, FoxPro 1.0+, Informix 7.0+, Ingres 2.5+, ODBC 2.0+, Oracle 8.0+, Progress 8.0+, Red Brick 5.0+, SAS 1.0+, SQL Server 7.0-8.0, Sybase 12.5+, Teradata 2.0+, DB2 for i 4.0+, Sybase IQ 12.5+, MySQL 5.0+
Schema_RefDB2 for LUW 9.1+, DB2 for z/OS 8.1+, SQL Server 9.0+, SQL Azure 10.0+
Script_Templates_RefAll
Select_Top_PercentageTeradata 2.6+
Select_Top_Rows_CountDB2 for LUW 9.1+, DB2 for z/OS 9.1+, Teradata 2.6+
Select_TypeAll
Select_With_TiesTeradata 2.6+
Shapes_RefAll
Start_With_ConditionOracle 8.1+
Stored_Procedures_RefAll
Teradata_Database_RefTeradata 2.5+
Teradata_RecursiveTeradata 2.6+
Teradata_View_Locking_ClauseTeradata 2.0-2.0
Theme_RefAll
Triggers_Order_RefDB2 for LUW 9.1+, DB2 for z/OS 8.1+, Teradata 2.5+, SQL Azure 10.0+
TypeAll
Use_Replace_SyntaxDB2 for LUW 9.7+, Oracle 8.1+, Teradata 2.5+
User_Defined_SQLAll
User_Formatted_NameAll
User_Formatted_Physical_NameAll
Where_ClauseAll