To get all tables in Amazon Redshift, you can use the following query:

SELECT t.table_name
FROM information_schema.tables t
WHERE t.table_schema = 'your_schema_name'
ORDER BY 1

Replace 'your_schema_name' with the name of the schema you want to retrieve the tables from. This query will return a list of table names in the specified schema.