CREATE TABLE t (x INT WITH SYSTEM VERSIONING, y INT);

SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='t'\G

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

           TABLE_CATALOG: def

            TABLE_SCHEMA: test

              TABLE_NAME: t

             COLUMN_NAME: x

        ORDINAL_POSITION: 1

          COLUMN_DEFAULT: NULL

             IS_NULLABLE: YES

               DATA_TYPE: int

CHARACTER_MAXIMUM_LENGTH: NULL

  CHARACTER_OCTET_LENGTH: NULL

       NUMERIC_PRECISION: 10

           NUMERIC_SCALE: 0

      DATETIME_PRECISION: NULL

      CHARACTER_SET_NAME: NULL

          COLLATION_NAME: NULL

             COLUMN_TYPE: int(11)

              COLUMN_KEY: 

                   EXTRA: 

              PRIVILEGES: select,insert,update,references

          COLUMN_COMMENT: 

            IS_GENERATED: NEVER

   GENERATION_EXPRESSION: NULL

*************************** 2. row ***************************

           TABLE_CATALOG: def

            TABLE_SCHEMA: test

              TABLE_NAME: t

             COLUMN_NAME: y

        ORDINAL_POSITION: 2

          COLUMN_DEFAULT: NULL

             IS_NULLABLE: YES

               DATA_TYPE: int

CHARACTER_MAXIMUM_LENGTH: NULL

  CHARACTER_OCTET_LENGTH: NULL

       NUMERIC_PRECISION: 10

           NUMERIC_SCALE: 0

      DATETIME_PRECISION: NULL

      CHARACTER_SET_NAME: NULL

          COLLATION_NAME: NULL

             COLUMN_TYPE: int(11)

              COLUMN_KEY: 

                   EXTRA: 

              PRIVILEGES: select,insert,update,references

          COLUMN_COMMENT: 

            IS_GENERATED: NEVER

   GENERATION_EXPRESSION: NULL

2 rows in set (0.001 sec)