list tables in redshift using SQLWorkbench

database amazon-web-services amazon-redshift sql-workbench-j
roy picture roy · Jun 5, 2014 · Viewed 9.8k times · Source

How do I list tables in redshift ?

I am using SQLWorkbench.

I tried SHOW TABLES; and \dt are not recognized commands.

Any help?

Answer

Mukul Bhardwaj picture Mukul Bhardwaj · May 22, 2017

On Sql workbench,

Go to Tools -> New DBexplorerWindow

it will load all the tables and click on table name shown the table schema as well

Hope this is helpfull.

Related questions

What is the recommended way to delete a large number of items from DynamoDB?

I'm writing a simple logging service in DynamoDB. I have a logs table that is keyed by a user_id hash and a timestamp (Unix epoch int) range. When a user of the service terminates their account, I need to …

Read More
AWS MySQL RDS vs AWS DynamoDB

I've been using MySQL for a fair while now and I'm comfortable with its structure & SQL Queries etc. Currently building a new system in AWS and I've been looking at DynamoDB. Currently I only know a little about it. …

Read More
AWS: can't connect to RDS database from my machine

The EC2 instance/live web can connect just fine to the RDS database. But when I want to debug the code in my local machine, I can't connect to the database and got this error: OperationalError: (2003, "Can't connect to MySQL …

Read More