Sometimes, it can happen that you want to modify field properties, such as adding a primary key or changing the length of certain fields. However, even in these situations, you might encounter some unusual behaviors that you should be prepared for.
To modify attributes, like changing from nullable to non-nullable or setting a different primary key, you must clear the table before applying these changes. No error messages were encountered when altering nullable to required. All felt as if the change was commited. If a field is already set as required, adding it to the primary key might not necessitate clearing the table.