Knowledge Drop

SQL RUNNER & DATABASE (HowTo): Create Schema in SQL Runner


Userlevel 3
Badge

Last tested: Oct 23, 2018
 

It is possible to create a new schema in the database by sending the command from SQL Runner
eg: CREATE SCHEMA schema_name ; (Redshift syntax)

⚠️ One thing to know is that the schema may not appear in the system after the creation until a table is added to the schema!

 ⚠️ User must also have CREATE permission on db http://docs.aws.amazon.com/redshift/latest/dg/r_GRANT.html

 

This content is subject to limited support.                

 

 


0 replies

Be the first to reply!

Reply