window.runtime property | window.runtime.flash.data.SQLColumnSchema |
Inheritance | SQLColumnSchema Object |
Runtime Versions: | 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.
See also
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 | ||
prototype : Object [static]
A reference to the prototype object of a class or function object. | Object |
Method | Defined By | ||
---|---|---|---|
SQLColumnSchema(name:String, primaryKey:Boolean, allowNull:Boolean, autoIncrement:Boolean, dataType:String, defaultCollationType:String)
Constructs a SQLColumnSchema instance. | SQLColumnSchema | ||
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 |
allowNull | property |
allowNull:Boolean
[read-only] Runtime Versions: | 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.
autoIncrement | property |
autoIncrement:Boolean
[read-only] Runtime Versions: | 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.
dataType | property |
dataType:String
[read-only] Runtime Versions: | 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.
defaultCollationType | property |
defaultCollationType:String
[read-only] Runtime Versions: | 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.BINARY
indicates that the column uses theBINARY
collation sequence.SQLCollationType.NO_CASE
indicates that the column uses theNOCASE
collation sequence, meaning that text comparisons are made in a case-insensitive manner.
See also
name | property |
name:String
[read-only] Runtime Versions: | 1.0 |
Gets the name of the column.
primaryKey | property |
primaryKey:Boolean
[read-only] Runtime Versions: | 1.0 |
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 | () | Constructor |
public function SQLColumnSchema(name:String, primaryKey:Boolean, allowNull:Boolean, autoIncrement:Boolean, dataType:String, defaultCollationType:String)
Runtime Versions: | 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:
|
See also
Thu Sep 29 2011, 02:34 AM -07:00