feat(tsql): add alter table rename

tobymao · tobymao · commit 1105044fa8c5 · 2024-04-19T09:17:03.000-07:00
diff --git a/sqlglot/dialects/tsql.py b/sqlglot/dialects/tsql.py
@@ -1052,3 +1052,14 @@ def _uncast_text(self, expression: exp.Expression, name: str) -> str:
 
         def partition_sql(self, expression: exp.Partition) -> str:
             return f"WITH (PARTITIONS({self.expressions(expression, flat=True)}))"
+
+        def altertable_sql(self, expression: exp.AlterTable) -> str:
+            actions = expression.args["actions"]
+            if isinstance(actions[0], exp.RenameTable):
+                table = self.sql(expression.this)
+                target = actions[0].this
+                target = self.sql(
+                    exp.table_(target.this) if isinstance(target, exp.Table) else target
+                )
+                return f"EXEC sp_rename '{table}', '{target}'"
+            return super().altertable_sql(expression)
diff --git a/tests/dialects/test_duckdb.py b/tests/dialects/test_duckdb.py
@@ -1075,6 +1075,7 @@ def test_rename_table(self):
             write={
                 "snowflake": "ALTER TABLE db.t1 RENAME TO db.t2",
                 "duckdb": "ALTER TABLE db.t1 RENAME TO t2",
+                "tsql": "EXEC sp_rename 'db.t1', 't2'",
             },
         )
 

Original file line number	Diff line number	Diff line change
`@@ -1075,6 +1075,7 @@ def test_rename_table(self):`
`1075`	`1075`	`write={`
`1076`	`1076`	`"snowflake": "ALTER TABLE db.t1 RENAME TO db.t2",`
`1077`	`1077`	`"duckdb": "ALTER TABLE db.t1 RENAME TO t2",`
	`1078`	`+ "tsql": "EXEC sp_rename 'db.t1', 't2'",`
`1078`	`1079`	`},`
`1079`	`1080`	`)`
`1080`	`1081`