• Hi

    'The drop table statement fails is incorrect. This one probably has you thinking about whether the synonym prevents the drop from occurring (similar to schema binding) but it does not, so The drop table statement succeeds is correct. '

    this is not true - as the synonym has first preference - unless we drop synonym first.

    secondly, the table created is Test and not test - so in case sensitive SQL server set up - it will not work.

    Regards