|
<< Click to Display Table of Contents >> Navigation: Connectors > MySQL > Tables and Views |
The DTS MySQL Connector fully supports all tables and views in MySQL and does not differentiate between the two.
DTS Name |
<table_or_view_name> |
DTS Key |
<schema_name>.<table_or_view_name> |
The connector is also capable of extracting metadata regarding the table/view columns:
▪DATA_TYPE
▪CHARACTER_MAXIMUM_LENGTH
▪NUMERIC_PRECISION
▪DATETIME_PRECISION
▪NUMERIC_SCALE
▪IS_NULLABLE
▪ORDINAL_POSITION
▪CONSTRAINT -> PRIMARY_KEY
Standard functionality only makes use of DATA_TYPE, ORDINAL_POSITION and PRIMARY_KEY, but the other items are available for extension in DTS descriptor objects.