root@spaceman:/home/snen# mariadb

Welcome to the MariaDB monitor.  Commands end with ; or \g.

Your MariaDB connection id is 40654

Server version: 11.4.4-MariaDB-deb11-log mariadb.org binary distribution

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> use my_db;

Database changed

MariaDB [my_db]> CREATE TABLE `t`(

    -> `id` int(10) unsigned DEFAULT NULL

    -> ) ENGINE=InnoDB DATA DIRECTORY='/ssdext/mysql_arch_tables';

Query OK, 0 rows affected (0,006 sec)

MariaDB [my_db]> SHOW CREATE TABLE `t` \G

*************************** 1. row ***************************

       Table: t

Create Table: CREATE TABLE `t` (

  `id` int(10) unsigned DEFAULT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci DATA DIRECTORY='/ssdext/mysql_arch_tables/'

1 row in set (0,001 sec)

MariaDB [my_db]> ALTER TABLE `t` DISCARD TABLESPACE;

Query OK, 0 rows affected (0,010 sec)

MariaDB [my_db]> SHOW CREATE TABLE `t` \G

*************************** 1. row ***************************

       Table: t

Create Table: CREATE TABLE `t` (

  `id` int(10) unsigned DEFAULT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci

1 row in set (0,001 sec)