Difference between revisions of "AUTOSUGGESTIONS Column Constraint"
From Lianjapedia
Yvonne.milne (Talk | contribs) (Created page with "==Purpose== Column constraint to specify the autosuggestions for a column ==Syntax== SET AUTOSUGGESTIONS <expC> ==See Also== ALTER TABLE, Autosuggestions, SQL Cons...") |
Barrymavin (Talk | contribs) (→Example) |
||
Line 16: | Line 16: | ||
<code lang="recital"> | <code lang="recital"> | ||
open database southwind | open database southwind | ||
− | alter table "customers" modify constraint contacttitle set autosuggestions 'select distinct contacttitle,contactname from customers' | + | alter table "customers" modify constraint contacttitle; |
− | alter table "customers" modify constraint contacttitle set autosuggestionheaders 'Title,Name' | + | set autosuggestions 'select distinct contacttitle,contactname from customers' |
+ | alter table "customers" modify constraint contacttitle; | ||
+ | set autosuggestionheaders 'Title,Name' | ||
</code> | </code> | ||
Latest revision as of 20:57, 28 March 2018
Contents
Purpose
Column constraint to specify the autosuggestions for a column
Syntax
SET AUTOSUGGESTIONS <expC>
See Also
ALTER TABLE, Autosuggestions, CONSTRAINTS, CREATE TABLE, Data Mapping, FIELDAUTOSUGGESTIONS(), FIELDAUTOSUGGESTIONHEADERS(), FIELDCHOICES(), GETDATAMAPPING(), INDEX, KEYLOOKUP(), SETDATAMAPPING(),
Description
A constraint is used to define rules that help to provide data integrity. Column constraints are specific to the column name specified. You must have ALTER privilege on the table. The table will be locked for EXCLUSIVE use during the operation.
The AUTOSUGGESTIONS column constraint is used to specify the autosuggestions for a column.
Example
open database southwind alter table "customers" modify constraint contacttitle; set autosuggestions 'select distinct contacttitle,contactname from customers' alter table "customers" modify constraint contacttitle; set autosuggestionheaders 'Title,Name'