Amazon Redshift : drop table if exists

amazon-redshift
Attilah picture Attilah · Nov 24, 2013 · Viewed 16.4k times · Source

Does Redshift support any statement equivalent to the following?

DROP TABLE IF EXISTS tablename

Answer

mark.monteiro picture mark.monteiro · Oct 29, 2014

This is supported in the latest version of Redshift: 

DROP TABLE [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]

IF EXISTS Clause that indicates that if the specified table doesn’t exist, the command should make no changes and return a message that the table doesn't exist, rather than terminating with an error.

This clause is useful when scripting, so the script doesn’t fail if DROP TABLE runs against a nonexistent table.

Taken from online AWS Redshift docs.

Related questions

Show tables, describe tables equivalent in redshift

I'm new to aws, can anyone tell me what are redshifts' equivalents to mysql commands? show tables -- redshift command describe table_name -- redshift command

Read More
Alter column data type in Amazon Redshift

How to alter column data type in Amazon Redshift database? I am not able to alter the column data type in Redshift; is there any way to modify the data type in Amazon Redshift?

Read More
In Redshift/Postgres, how to count rows that meet a condition?

I'm trying to write a query that count only the rows that meet a condition. For example, in MySQL I would write it like this: SELECT COUNT(IF(grade < 70), 1, NULL) FROM grades ORDER BY id DESC; However, when I …

Read More