flash.data

# SQLViewSchema - AS3

Package | flash.data
Class | public class SQLViewSchema
Inheritance | SQLViewSchema SQLTableSchema SQLSchema 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

flash.data.SQLConnection.loadSchema()
flash.data.SQLColumnSchema

Public Properties
Hide Inherited Public Properties
Show Inherited Public Properties

| Property | Defined By
--- | --- | ---
|  | columns : Array [read-only] An array of SQLColumnSchema instances containing schema information for this table's columns. | SQLTableSchema
|  | constructor : Object A reference to the class object or constructor function for a given object instance. | Object
|  | database : String [read-only] The name of the database to which this schema object belongs. | SQLSchema
|  | name : String [read-only] The name of this schema object. | SQLSchema
|  | sql : String [read-only] Returns the entire text of the SQL statement that was used to create this schema object. | SQLSchema

Public Methods
Hide Inherited Public Methods
Show Inherited Public Methods

| Method | Defined By
--- | --- | ---
|  | SQLViewSchema(database:String, name:String, sql:String, columns:Array) Creates a SQLViewSchema instance. | SQLViewSchema
|  | hasOwnProperty(name:String):Boolean Indicates whether an object has a specified property defined. | Object
|  | isPrototypeOf(theClass:Object):Boolean Indicates whether an instance of the Object class is in the prototype chain of the object specified as the parameter. | Object
|  | propertyIsEnumerable(name:String):Boolean Indicates whether the specified property exists and is enumerable. | Object
|  | setPropertyIsEnumerable(name:String, isEnum:Boolean = true):void Sets the availability of a dynamic property for loop operations. | Object
|  | toLocaleString():String Returns the string representation of this object, formatted according to locale-specific conventions. | Object
|  | toString():String Returns the string representation of the specified object. | Object
|  | valueOf():Object 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.

© 2015 Adobe Systems Incorporated. All rights reserved.
Mon Apr 10 2017, 12:28 PM -07:00