| Package | flash.data |
| Class | public class SQLColumnSchema |
| Inheritance | SQLColumnSchema  Object |
| Language Version: | ActionScript 3.0 |
| Runtime Versions: | AIR 1.0 |
To obtain column schema information for one or more tables in a database, use the
SQLConnection.loadSchema() method to load the schema information, making certain to
use true for the includeColumnSchema argument's value. In the resulting
SQLSchemaResult instance, each table and view definition includes a columns
property — an array of SQLColumnSchema instances representing the columns in the
table or view.
Generally, developer code does not construct SQLColumnSchema instances directly.
Related API Elements
Hide Inherited Public Properties
Show Inherited Public Properties| Property | Defined By | ||
|---|---|---|---|
| allowNull : Boolean [read-only]
Indicates whether NULL values are allowed in this column. | SQLColumnSchema | ||
| autoIncrement : Boolean [read-only]
Indicates whether this is an auto-increment column. | SQLColumnSchema | ||
 | constructor : Object
A reference to the class object or constructor function for a given object instance. | Object | |
| dataType : String [read-only]
Gets the data type of the column as a string. | SQLColumnSchema | ||
| defaultCollationType : String [read-only]
Indicates the default collation sequence that is defined for this column. | SQLColumnSchema | ||
| name : String [read-only]
Gets the name of the column. | SQLColumnSchema | ||
| primaryKey : Boolean [read-only]
Indicates whether this column is the primary key column (or one of the primary key columns
in a composite key) for its associated table. | SQLColumnSchema | ||
| Method | Defined By | ||
|---|---|---|---|
SQLColumnSchema(name:String, primaryKey:Boolean, allowNull:Boolean, autoIncrement:Boolean, dataType:String, defaultCollationType:String)
Constructs a SQLColumnSchema instance. | SQLColumnSchema | ||
|
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 | |
allowNull | property |
allowNull:Boolean [read-only] | Language Version: | ActionScript 3.0 |
| Runtime Versions: | AIR 1.0 |
Indicates whether NULL values are allowed in this column. A column
that is declared with a NOT NULL constraint has a false
value for the allowNull property.
Implementation
public function get allowNull():Boolean autoIncrement | property |
autoIncrement:Boolean [read-only] | Language Version: | ActionScript 3.0 |
| Runtime Versions: | AIR 1.0 |
Indicates whether this is an auto-increment column. An auto-increment column is a special type
of PRIMARY KEY column whose value is automatically generated as the next value
in a sequence of integers when a new row is inserted into the table.
Implementation
public function get autoIncrement():Boolean dataType | property |
dataType:String [read-only] | Language Version: | ActionScript 3.0 |
| Runtime Versions: | AIR 1.0 |
Gets the data type of the column as a string. The value is the literal data type name that was
specified in the CREATE TABLE statement that was used to define the table, or
null if no data type was specified.
Implementation
public function get dataType():String defaultCollationType | property |
defaultCollationType:String [read-only] | Language Version: | ActionScript 3.0 |
| Runtime Versions: | AIR 1.0 |
Indicates the default collation sequence that is defined for this column. The value of this property corresponds to one of the constants in the SQLCollationType class:
SQLCollationType.BINARYindicates that the column uses theBINARYcollation sequence.SQLCollationType.NO_CASEindicates that the column uses theNOCASEcollation sequence, meaning that text comparisons are made in a case-insensitive manner.
Implementation
public function get defaultCollationType():StringRelated API Elements
name | property |
primaryKey | property |
SQLColumnSchema | () | Constructor |
public function SQLColumnSchema(name:String, primaryKey:Boolean, allowNull:Boolean, autoIncrement:Boolean, dataType:String, defaultCollationType:String)| Language Version: | ActionScript 3.0 |
| Runtime Versions: | AIR 1.0 |
Constructs a SQLColumnSchema instance. Generally, developer code does not call the SQLColumnSchema
constructor directly. To obtain schema information for a database, call the
SQLConnection.loadSchema() method.
name:String — The name of the column.
| |
primaryKey:Boolean — Indicates whether this column is a part of the primary
key for the associated table.
| |
allowNull:Boolean — Indicates whether this column can contain NULL values.
| |
autoIncrement:Boolean — Indicates whether this is an auto increment column.
| |
dataType:String — The declared type of the column.
| |
defaultCollationType:String — The collation sequence defined for this column.
This value corresponds to one of the constants in the SQLCollationType class:
|
Related API Elements
Mon Apr 10 2017, 12:28 PM -07:00