MariaDB [kmantest]> show create table odbc_except;
+-------------+---------------------------------------------------------------------------------------+
| Table       | Create Table                                                                          |
+-------------+---------------------------------------------------------------------------------------+
| odbc_except | CREATE TABLE `odbc_except` (
  `EMPL` varchar(4) NOT NULL,
  `ITEM` varchar(13) NOT NULL,
  `ORDERNO` varchar(13) NOT NULL,
  `IDEN` varchar(7) DEFAULT NULL,
  `LOCAT` decimal(15,0) DEFAULT NULL,
  `JACTDATE` decimal(15,0) DEFAULT NULL,
  `COMMEN` varchar(26) DEFAULT NULL,
  `PROGRAM` varchar(13) DEFAULT NULL,
  `MADEBY` varchar(4) DEFAULT NULL,
  `ACTTIME` varchar(6) DEFAULT NULL,
  `LOGGEDIN` varchar(13) DEFAULT NULL,
  `NOTES` varchar(401) DEFAULT NULL,
  PRIMARY KEY (`EMPL`,`ORDERNO`,`ITEM`)
) ENGINE=CONNECT DEFAULT CHARSET=utf8 CONNECTION='DSN=KMANTEST' `table_type`=ODBC `tabname`=EXCEPT |
+-------------+---------------------------------------------------------------------------------------+
1 row in set (0.00 sec)