How do I list tables in a schema?
How do I list tables in a schema? SELECT table_name, table_schema, table_type FROM information_schema. tables ORDER BY table_name ASC; This will show the name of the table, which schema it belongs to, and the type. The type will either be “BASE TABLE” for tables or “VIEW” for views. How do you view the schema of […]