Packageflash.data
Classpublic class SQLTriggerSchema
InheritanceSQLTriggerSchema Inheritance SQLSchema Inheritance Object

Language version: ActionScript 3.0
Runtime version: 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.

See also

flash.data.SQLConnection.loadSchema()


Public Properties
 PropertyDefined by
 Inheritedconstructor : Object
A reference to the class object or constructor function for a given object instance.
Object
 Inheriteddatabase : String
The name of the database to which this schema object belongs.
SQLSchema
 Inheritedname : String
The name of this schema object.
SQLSchema
 Inheritedprototype : Object
[static] A reference to the prototype object of a class or function object.
Object
 Inheritedsql : String
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
 MethodDefined by
  
SQLTriggerSchema(database:String, name:String, sql:String, table:String)
Creates a SQLTriggerSchema instance.
SQLTriggerSchema
 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
Property detail
tableproperty
table:String  [read-only]

Language version: ActionScript 3.0
Runtime version: 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 version: 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.