Little strange but somehow the schema name had to enclosed within square brackets.

Thanks to @Thom A for his clear screenshot image to provide me the hint!