I would expect for the query to complete successfully if the table already exists, without trying to create anything - Replica included. The reason why think that this behavior is unexpected is ...

Hi @mumincelal — it's currently not possible to write your schema in such a way that migrate will generate CREATE TABLE IF NOT EXISTS, and in general it is going to conflict with how migration ...

is the name for the constraint being specified. The first form of the CREATE TABLE statement creates tables that automatically map SQL data types to those supported by the SAS System. Use this form ...

How to Create a Table From Query Results in Microsoft SQL. If your business uses relational databases to store data, you may have used a SQL SELECT clause to create new tables from query results.