How to check if a table is system versioned for MariaDB?

Question

How to check if a table is system versioned for MariaDB ?

This post refers to same question on "SQL Server 2016"

How to check if the SYSTEM_VERSIONING for a table is ON?

I've tried this syntax on MariaDB, but I got error.

I guess "TableTemporalType", is MS specific

(see https://learn.microsoft.com/en-us/sql/t-sql/functions/objectproperty-transact-sql?view=sql-server-ver15 )

Anyone knows how can be done in MariaDB ?

Thanks for your help.

Answer 1

SELECT TABLE_TYPE
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = database_name
  AND TABLE_NAME = table_name;