• "SET PROPERTIES" syntax is optional for both Create and Alter syntax.

• Annotation, if any specified on the folder is saved into the folder metadata as well.

• Use the "CREATE FOLDER IF NOT EXISTS" syntax to create a new folder to avoid any error messages to be displayed when the folder already exists.

• By default Read, Write and Grant privileges are provided to the owner and all privileges to the admin users or users in admin group.

• Alter folder syntax supports both relocate and rename operations of folders. When a folder is relocated to another parent path, and if the parent path does not exist, it is created automatically before folder is created. When a folder is relocated to another path that already exists, an error is thrown. Note that there is no IF NOT EXISTS syntax on "alter folder" command.

• "RELOCATE TO" syntax is used for relocating the folders as well as renaming folders.

• The created folder can be viewed from the Studio as well.

• When a folder is created or altered, the model.ALL_RESOURCE_PROPERTIES table is updated with the properties of the folder like "annotation".