select
table_name,
table_type
from
information_schema.tables
where
table_schema = 'bijonathan'
See SQLStdCompletionQuery.java
notice that in MySQL 5.5 there is no restriction on the use of punctuation/periods in Schema Object Names
http://dev.mysql.com/doc/refman/5.5/en/identifiers.html
however, in MySQL 5.0 there are restrictions on the use of periods in Schema Object Names
http://dev.mysql.com/doc/refman/5.0/en/identifiers.html
Database and table names cannot contain “
/”, “\”, “.”, or characters that are not permitted in file names.
notice that in MySQL 5.5 there is no restriction on the use of punctuation/periods in Schema Object Names
http://dev.mysql.com/doc/refman/5.5/en/identifiers.html
however, in MySQL 5.0 there are restrictions on the use of periods in Schema Object Names
http://dev.mysql.com/doc/refman/5.0/en/identifiers.html
Database and table names cannot contain “
/”, “\”, “.”, or characters that are not permitted in file names.
Issue #11480 |
| Closed |
| Fixed |
| Resolved |
Completion |
| No due date |
| Fixed Build 14.0.8-3 |
| No time estimate |
See SQLStdCompletionQuery.java