1  –  ALIAS aliasname

    When attached to multiple databases, the aliasname is required to
    direct the DROP command to the appropriate database.

2  –  CASCADE

    This option causes all user definitions to be altered to remove
    the reference to this profile.

3  –  DEFAULT_PROFILE

    Drops the special profile RDB$DEFAULT_PROFILE.

4  –  IF_EXISTS

    Prevents SQL command language from displaying error messages if
    the referenced object does not exist in the database.

5  –  RESTRICT

    If the profile is used by a user in the database, the DROP
    PROFILE statement will fail. This is the default.