Get all table names from database in sql



This basically provides access to the database metadata like name of the database, name of tables, columns, etc. so for this purpose we will access a table named ‘tables’ in information_schema using the following query

 
SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE='BASE TABLE'
 
 

0 Comment's

Comment Form