MySql Query to find information about a DB

Posted by Jagadeesh VP | Posted in

To get the general information about a DataBase/Schema in My Sql.

SELECT * FROM information_schema.`TABLES` T where TABLE_SCHEMA like '[DATABASE_NAME]';

Note : You should have access to the database.

Comments (0)

Post a Comment