Information base is a one of the significant information models with various ascribes that you can alter according to your necessities.
The accompanying assertion is the essential grammar of the Alter Database order.
ALTER DATABASE <attribute-name> <attribute-value>
Where <attribute-name> characterizes the characteristic that you need to adjust and <attribute-value> characterizes the worth you need to set for that property.
The accompanying table characterizes the rundown of upheld ascribes for adjusting a data set.
| Sr.No. | Attribute Name | Description |
|---|---|---|
| 1 | STATUS | Defines the database’s status between different attributes. |
| 2 | IMPORTING | Sets the importing status. |
| 3 | DEFAULTCLUSTERID | Sets the default cluster using ID. By default it is 2. |
| 4 | DATEFORMAT | Sets the particular date format as default. By default it is "yyyy-MM-dd". |
| 5 | DATETIMEFORMAT | Sets the particular date time format as default. By default it is "yyyy-MM-dd HH:mm:ss". |
| 6 | TIMEZONE | Sets the particular time zone. By default it is Java Virtual Machine’s (JVM’s) default time zone. |
| 7 | LOCALECOUNTRY | Sets the default locale country. By default it is JVM’s default locale country. For example: "GB". |
| 8 | LOCALELANGUAGE | Sets the default locale language. By default it is JVM’s default locale language. For example: "en". |
| 9 | CHARSET | Sets the type of character set. By default it is JVM’s default charset. For example: "utf8". |
| 10 | CLUSTERSELECTION | Sets the default strategy used for selecting the cluster. These strategies are created along with the class creation. Supported strategies are default, roundrobin, and balanced. |
| 11 | MINIMUMCLUSTERS | Sets the minimum number of clusters to create automatically when a new class is created. By default it is 1. |
| 12 | CUSTOM | Sets the custom property. |
| 13 | VALIDATION | Disables or enables the validations for entire database. |
Example
From the rendition of OrientDB-2.2, the new SQL parser is added which won't permit the normal language structure now and again. Subsequently, we need to handicap the new SQL parser (StrictSQL) sometimes. You can utilize the accompanying Alter information base order to impair the StrictSQL parser.
orientdb> ALTER DATABASE custom strictSQL = false
In the event that the order is executed effectively, you will get the accompanying yield.
Database updated successfully
