Answers for "all tables from database sql"

how to get all tables in sql

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

Posted by: Guest on June-05-2020

get tables in database sql

SELECT
  *
FROM
  INFORMATION_SCHEMA.TABLES;

Posted by: Guest on April-15-2021

Code answers related to "all tables from database sql"