> For the complete documentation index, see [llms.txt](https://docs.mydbsync.com/cloud-replication-main/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.mydbsync.com/cloud-replication-main/additional-configuration-settings/force-property.md).

# Force Property

 Force property helps to alter the datatype and size of a column in the database. This feature is applicable when the column is created in the database. It is not applicable to alter existing column in the database.

To enable this feature, please follow the below steps.

* Edit **system.properties** under **<\<install-folder>>\dbsync-repl\WEB-INF\db\conf** and include the command \
  FORCE.<\<COLUMN\_NAME>>=<\<data\_type(size)>>
* Following are some of the examples

1. FORCE.ID=nchar(18)
2. FORCE.DATE= datetime(6)
3. FORCE.TEST\_\_C=varchar(100)