v5:dictionary:column_attributes
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
v5:dictionary:column_attributes [2016/04/03 01:10] – [INDEX] mnewnham | v5:dictionary:column_attributes [2022/09/02 04:11] (current) – [Column Name] backticks mnewnham | ||
---|---|---|---|
Line 2: | Line 2: | ||
====== Description ====== | ====== Description ====== | ||
When creating a column in a table using the dictionary methods, the information provided must confirm to the following specification. Each column created has a number of mandatory and optional parameters. | When creating a column in a table using the dictionary methods, the information provided must confirm to the following specification. Each column created has a number of mandatory and optional parameters. | ||
- | -------------------------------- | + | |
- | <WRAP right info 300px> | + | |
- | $fields is a string, not an array | + | |
- | </ | + | |
====== Basic Syntax ====== | ====== Basic Syntax ====== | ||
The basic syntax of the attributes is as follows: | The basic syntax of the attributes is as follows: | ||
Line 41: | Line 38: | ||
======= | ======= | ||
===== Column Name ===== | ===== Column Name ===== | ||
- | * The column name must conform to any database specific standards related to naming and length. | + | * The column name must conform to any database specific standards related to naming and length. |
- | + | ||
===== Meta Attributes ===== | ===== Meta Attributes ===== | ||
* The column attributes in terms of type and length **must** be specified in terms of ADODb [[v5: | * The column attributes in terms of type and length **must** be specified in terms of ADODb [[v5: | ||
Line 60: | Line 56: | ||
</ | </ | ||
==== CONSTRAINT ==== | ==== CONSTRAINT ==== | ||
+ | Adds a constraint to column. The syntax for the constraint must be defined as required by the database. | ||
-------------------------- | -------------------------- | ||
<WRAP right box 150px> | <WRAP right box 150px> | ||
Line 84: | Line 80: | ||
</ | </ | ||
==== ENUM ==== | ==== ENUM ==== | ||
- | In databases that support the ENUM datatype, append a parenthesized, | + | In databases that support the //**ENUM**// datatype, append a parenthesized, |
ENUM(' | ENUM(' | ||
| | ||
Line 96: | Line 92: | ||
Creates a single column index using the same name as the column, with ' | Creates a single column index using the same name as the column, with ' | ||
------------------------------- | ------------------------------- | ||
- | ==== KEY ==== | ||
- | -------------------------------- | + | <WRAP right box 150px> |
+ | ** Usage: Any ** | ||
+ | </ | ||
==== NOQUOTE ==== | ==== NOQUOTE ==== | ||
+ | Prevents ADOdb from applying the normal quoting rules to tables, columns and indexes. For example, a column name that contains a special character such as // | ||
-------------------------------- | -------------------------------- | ||
<WRAP right box 150px> | <WRAP right box 150px> | ||
Line 111: | Line 108: | ||
**Usage: Column** | **Usage: Column** | ||
</ | </ | ||
- | ==== PRIMARY ==== | + | ==== PRIMARY |
Indicates if the column is part of the [[wp> | Indicates if the column is part of the [[wp> | ||
--------------------------- | --------------------------- | ||
Line 125: | Line 122: | ||
</ | </ | ||
==== UNSIGNED ==== | ==== UNSIGNED ==== | ||
+ | Creates an unsigned integer. |
v5/dictionary/column_attributes.1459638628.txt.gz · Last modified: 2017/04/21 11:28 (external edit)