If you see the error, it is clearly mentioned that 'test' schema is already exist, thats why u got that error. But while dropping the schema , it must be empty. ... View more