flash.data

# SQLTriggerSchema - AS3

Package | flash.data
Class | public class SQLTriggerSchema
Inheritance | SQLTriggerSchema SQLSchema Object

Language Version: | ActionScript 3.0

Runtime Versions: | AIR 1.0

A SQLTriggerSchema instance provides information describing a specific trigger in a database. It contains the name of the trigger (the `name` property), the name of the associated table (the `table` property), and the SQL statement used to create the trigger (the `sql` property).

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

Generally, developer code does not construct SQLTriggerSchema instances directly.

Related API Elements

flash.data.SQLConnection.loadSchema()

Public Properties
Hide Inherited Public Properties
Show Inherited Public Properties

| Property | Defined By
--- | --- | ---
|  | 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
|  | table : String [read-only] The name of the table on which this trigger is defined, or the name of the view if the trigger is defined on a view. | SQLTriggerSchema

Public Methods
Hide Inherited Public Methods
Show Inherited Public Methods

| Method | Defined By
--- | --- | ---
|  | SQLTriggerSchema(database:String, name:String, sql:String, table:String) Creates a SQLTriggerSchema instance. | SQLTriggerSchema
|  | 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

Property Detail

### table

property

`table:String` [read-only]

Language Version: | ActionScript 3.0

Runtime Versions: | AIR 1.0

The name of the table on which this trigger is defined, or the name of the view if the trigger is defined on a view.

Implementation
`public function get table():String`
Constructor Detail

### SQLTriggerSchema

()
Constructor

`public function SQLTriggerSchema(database:String, name:String, sql:String, table:String)`

Language Version: | ActionScript 3.0

Runtime Versions: | AIR 1.0

Creates a SQLTriggerSchema instance. Generally, developer code does not call the SQLTriggerSchema 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 trigger.
| `sql:String` — The SQL used to create the trigger.
| `table:String` — The name of the trigger's associated table.

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