The location clause within a table creation statement is deprecated and ignored ("LOCATION = USER_DB"). We can flag and automatically remove this.

This can be applied across the whole TSQL dialect as this specific formulation of the location clause will only be seen within Azure Synapse Analytics.

Anti-pattern

CREATE TABLE #UserDB
WITH (DISTRIBUTION = ROUND_ROBIN, HEAP, LOCATION = User_db)
AS
SELECT 1

Pattern

CREATE TABLE #UserDB
WITH (DISTRIBUTION = ROUND_ROBIN, HEAP)
AS
SELECT 1