How to get all tables and column names in SQL?

Question

I want a list of table names and columns within that table (see below). Is there a SQL query that would allow me to do this within a schema?

I know I can look at the GUI interface to look at the table names and columns but there are too many to look at manually.

Answer 1

however your question isn't enough clear but you can get all of it with this this code

SELECT * FROM INFORMATION_SCHEMA.COLUMNS