Change table properties in code

[Rachael]

Hi All,

How are table properties modified in code in a table that exists in a backend database. I want to change a field property from not indexed to indexed (no duplicates)

Thankyou to all repliers

Rachael

 

[smed]

Rachael,

To perform table changes use an SQL Query :


Create Index (Duplicates OK)
CREATE INDEX index_name
ON table_name (column_name)


Create Unique Index (No Duplicates)
CREATE UNIQUE INDEX index_name
ON table_name (column_name)


Hope this helps

Smed