> 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/overriding-databases-datatypes.md).

# Overriding Database's Datatypes

Overriding Database's Datatypes property helps to override default datatype in the database. 

To enable this property, please follow the below steps.

1. If table is already created/exist in database then set alter.schema.override=true in system.properties and alter.schema.size should be set to false
2. Edit **\<used-Database>.properties** under **<\<install-folder>>\dbsync-repl\WEB-INF\db\conf**
3. The datatype need to be overridden should be added like \<old\_datatype>.default=\<new\_datatype>\
   eg. to override varchar to text, we can write varchar.default=text\
   Note: This will change all varchar fields to new datatype or you can change the limit like Varchar (100) to Varchar (200) or any other number. \
   Remove the # tag before the picklist and save the changes and then run the build again.\
   To change only for specific field use [Force Property](http://help.mydbsync.com/docs/display/CloudReplication/Force+Property)

<br>