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