ActionScript® 3.0 Reference for the Adobe® Flash® Platform
Home  |  Show Packages and Classes List |  Packages  |  Classes  |  What's New  |  Index  |  Appendixes
flash.data 

SQLViewSchema  - AS3

Packageflash.data
Classpublic class SQLViewSchema
InheritanceSQLViewSchema Inheritance SQLTableSchema Inheritance SQLSchema Inheritance Object

Language Version: ActionScript 3.0
Runtime Versions: AIR 1.0

A SQLViewSchema instance provides information describing a specific view in a database. It contains the name of the view (the name property), the SQL statement used to create the view (the sql property), and information about the view's columns (the columns property).

To obtain view schema information for a database, use the SQLConnection.loadSchema() method to load the schema information, making certain to use null or SQLViewSchema for the type argument's value. In the resulting SQLSchemaResult instance, the views property contains an array of SQLViewSchema instances representing the views in the database.

Generally, developer code does not construct SQLViewSchema instances directly.

Related API Elements



Public Properties
 PropertyDefined By
 Inherited    columns : Array
[read-only] An array of SQLColumnSchema instances containing schema information for this table's columns.
SQLTableSchema
 Inheritedconstructor : Object
A reference to the class object or constructor function for a given object instance.
Object
 Inherited    database : String
[read-only] The name of the database to which this schema object belongs.
SQLSchema
 Inherited    name : String
[read-only] The name of this schema object.
SQLSchema
 Inherited    sql : String
[read-only] Returns the entire text of the SQL statement that was used to create this schema object.
SQLSchema
Public Methods
 MethodDefined By
  
    SQLViewSchema(database:String, name:String, sql:String, columns:Array)
Creates a SQLViewSchema instance.
SQLViewSchema
 Inherited
Indicates whether an object has a specified property defined.
Object
 Inherited
Indicates whether an instance of the Object class is in the prototype chain of the object specified as the parameter.
Object
 Inherited
Indicates whether the specified property exists and is enumerable.
Object
 Inherited
Sets the availability of a dynamic property for loop operations.
Object
 Inherited
Returns the string representation of this object, formatted according to locale-specific conventions.
Object
 Inherited
Returns the string representation of the specified object.
Object
 Inherited
Returns the primitive value of the specified object.
Object
Constructor Detail
    

SQLViewSchema

()Constructor
public function SQLViewSchema(database:String, name:String, sql:String, columns:Array)

Language Version: ActionScript 3.0
Runtime Versions: AIR 1.0

Creates a SQLViewSchema instance. Generally, developer code does not call the SQLViewSchema constructor directly. To obtain schema information for a database, call the SQLConnection.loadSchema() method.

Parameters
database:String — The name of the associated database.
 
name:String — The name of the view.
 
sql:String — The SQL statement used to create the view.
 
columns:Array — Array of SQLColumnSchema instances describing this view's columns.