When adding a field into a table the possibility of setting some attributes depends on the presence of records in the table (table 23-4).
Attribute | There are records in the table | No records in the table |
Indexed | Enabled | Enabled |
Unique | Disabled | Enabled |
Not empty | Disabled | Enabled |
Encrypted | Enabled | Enabled |
Table 23-4. Possibility of setting attributes when adding a field
The added field will have an empty value in all table records if they are any records in the table, of course.