Displaying 2 results from an estimated 2 matches for "tables_in_time".
2019 Apr 24
2
mariadb: How to delete foreign key constraint from non-existing table?
...ed, stationsnummer integer(4) unsigned, primary key (userID));
ERROR 1005 (HY000): Can't create table `time`.`etikettend_metainfo`
(errno: 150 "Foreign key constraint is incorrectly formed")
MariaDB [time]> show tables like 'etikettend%';
+------------------------------+
| Tables_in_time (etikettend%) |
+------------------------------+
| etikettend_etikettentypen |
| etikettend_stationen |
+------------------------------+
2 rows in set (0.001 sec)
Since the table has vanished, I'm finding myself unable to remove the
key constraints, and trying to disable them was...
2019 Apr 24
0
mariadb: How to delete foreign key constraint from non-existing table?
...r(4) unsigned, primary key (userID));
> ERROR 1005 (HY000): Can't create table `time`.`etikettend_metainfo`
> (errno: 150 "Foreign key constraint is incorrectly formed")
> MariaDB [time]> show tables like 'etikettend%';
> +------------------------------+
> | Tables_in_time (etikettend%) |
> +------------------------------+
> | etikettend_etikettentypen |
> | etikettend_stationen |
> +------------------------------+
> 2 rows in set (0.001 sec)
>
>
> Since the table has vanished, I'm finding myself unable to remove the
> key...