| Package | flash.data |
| Class | public class SQLTableSchema |
| Inheritance | SQLTableSchema  SQLSchema Object |
| Subclasses | SQLViewSchema |
| Language Version: | ActionScript 3.0 |
| Runtime Versions: | AIR 1.0 |
name property), the
SQL statement used to create the table (the sql property), and
information about the table's columns (the columns property).
To obtain table schema information for a database, use the
SQLConnection.loadSchema() method to load the schema information, making certain to
use null or SQLTableSchema for the type argument's value.
In the resulting SQLSchemaResult instance, the tables property contains an array
of SQLTableSchema instances representing the tables in the database.
Generally, developer code does not construct SQLTableSchema instances directly.
Related API Elements
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 | |
| Method | Defined By | ||
|---|---|---|---|
Creates a SQLTableSchema instance. | SQLTableSchema | ||
|
Indicates whether an object has a specified property defined. | Object | |
|
Indicates whether an instance of the Object class is in the prototype chain of the object specified
as the parameter. | Object | |
|
Indicates whether the specified property exists and is enumerable. | Object | |
|
Sets the availability of a dynamic property for loop operations. | Object | |
|
Returns the string representation of this object, formatted according to locale-specific conventions. | Object | |
|
Returns the string representation of the specified object. | Object | |
|
Returns the primitive value of the specified object. | Object | |
columns | property |
columns:Array [read-only] | Language Version: | ActionScript 3.0 |
| Runtime Versions: | AIR 1.0 |
An array of SQLColumnSchema instances containing schema information for this table's columns.
If the SQlConnection.loadSchema() call indicates that column information
is excluded from the result, the columns property is an empty array
(an array whose length property is 0).
Implementation
public function get columns():ArrayRelated API Elements
SQLTableSchema | () | Constructor |
public function SQLTableSchema(database:String, name:String, sql:String, columns:Array)| Language Version: | ActionScript 3.0 |
| Runtime Versions: | AIR 1.0 |
Creates a SQLTableSchema instance. Generally, developer code does not call the SQLTableSchema
constructor directly. To obtain schema information for a database, call the
SQLConnection.loadSchema() method.
database:String — The name of the associated database.
| |
name:String — The name of the table.
| |
sql:String — The SQL statement used to create the table.
| |
columns:Array — Array of SQLColumnSchema instances describing this table's columns.
|
Related API Elements
Wed Nov 21 2018, 06:34 AM -08:00