# Change Column

Source: https://help.codestencil.com/schema-dictionary/change-column

This allows you to update or make changes to a particular column.

![](https://cdn.eniston.com/bases/5691f589-9697-4a3a-b3a1-f6588fa2e596/attachments/mceclip0_1754992475.png)

1. **Name** – The property name of the column. Examples include `FirstName`, `LastName`, or any property defined in your model or class.
2. **Caption** – A human-readable title for the column. This can match the **Name** property or be a more descriptive label.
3. **Mapped Name** – This is an alternative (or additional) name for a column when it appears in the list of columns in a DTO (Data Transfer Object).  The **Mapped Name** field allows you to map the `Artist.Name` navigation property from the Album entity to the ArtistName string property in AlbumDto.  To check how this is being implemented and for more details, [click here](https://help.codestencil.com/schema-dictionary/mapped-name)
4. **Column Type** – The data type of the column or property (e.g., `string`, `int`, `DateTime`, `bool`).
5. **Size** – The maximum number of characters or the length the column can hold.
6. **Default Value** – The value automatically assigned to the column if no value is provided.
7. **Enabled** – A checkbox to indicate if this column should be included in the properties returned during code generation.
8. **Primary** – Marks the column as the **Primary Key** of the table.
9. **Foreign** – Marks the column as a **Foreign Key** linked to another table.
10. **Sortable** – Indicates whether the column can be sorted in lists or tables
11. **Searchable** – Indicates whether the column can be included in search queries or filters.
12. **Allow Nulls** – Specifies whether the column can store `NULL` values in the database.
13. **Is Not Visible****—**This option hides the column from the UI while keeping it part of the data model.
14. **Use Max Size** – Automatically sets the column to use the maximum possible size allowed by its data type.
15. **Is Unique** – Ensures that values in this column must be unique across all rows in the table.
16. **Set As Table Label** – Defines this column as the label for the table in dropdowns, reference fields, or related lookups throughout the application.
17. **Foreign Key** – The name of the key in the related table that this column references.
18. **Related Table** – The table contains the referenced data for this foreign key.
19. **Display Column** – The column from the related table to display when showing foreign key values in the dropdown.
20. **Clear** – Removes the current settings or values for the column configuration.
21. **Table Name** – The name of the current table the column belongs to.
