v5:dictionary:column_attributes
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
v5:dictionary:column_attributes [2016/04/03 01:09] – mnewnham | v5:dictionary:column_attributes [2016/04/03 01:33] – [Description] 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 60: | Line 57: | ||
</ | </ | ||
==== 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 94: | Line 91: | ||
</ | </ | ||
==== INDEX ==== | ==== INDEX ==== | ||
- | 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 109: | ||
**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 123: | ||
</ | </ | ||
==== UNSIGNED ==== | ==== UNSIGNED ==== | ||
+ | Creates an unsigned integer. |
v5/dictionary/column_attributes.txt · Last modified: 2022/09/02 04:11 by mnewnham