Update/Add Table definitions utility
- Last Updated: March 30, 2020
- 1 minute read
- OpenEdge
- Version 12.2
- Documentation
Update/Add Table definitions utility
The Update/Add Table Definitions utility allows you
to pull definitions from a table in a foreign data source. The table
may be new or already exist in the schema holder, in which case
you can add definitions or update definitions that are outdated.
By default, MS SQL Server DATETIME and SMALLDATETIME data
types are mapped to the OpenEdge DATE data type. The
utility allows you to change the mapping to OpenEdge DATETIME.
Note: Since time zone support is new in 10.2B, any
DATETIMEOFFSET column
pulled from an MSS SQL Server 2008 or later database is automatically
mapped to DATETIME-TZ by default.