diff options
| author | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-04-27 02:50:25 +0000 |
|---|---|---|
| committer | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-04-27 02:50:25 +0000 |
| commit | cf49728f719975144a958f23ba5f3336fb81ae55 (patch) | |
| tree | 78aa5446e86cc5623808508ee167c9a476754939 /sqlglot/dialects/tsql.py | |
| parent | Releasing debian version 23.10.0-1. (diff) | |
| download | sqlglot-cf49728f719975144a958f23ba5f3336fb81ae55.tar.xz sqlglot-cf49728f719975144a958f23ba5f3336fb81ae55.zip | |
Merging upstream version 23.12.1.
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
Diffstat (limited to 'sqlglot/dialects/tsql.py')
| -rw-r--r-- | sqlglot/dialects/tsql.py | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/sqlglot/dialects/tsql.py b/sqlglot/dialects/tsql.py index 6eed46d..a699f2b 100644 --- a/sqlglot/dialects/tsql.py +++ b/sqlglot/dialects/tsql.py @@ -464,6 +464,7 @@ class TSQL(Dialect): "SMALLMONEY": TokenType.SMALLMONEY, "SQL_VARIANT": TokenType.VARIANT, "TOP": TokenType.TOP, + "TIMESTAMP": TokenType.ROWVERSION, "UNIQUEIDENTIFIER": TokenType.UNIQUEIDENTIFIER, "UPDATE STATISTICS": TokenType.COMMAND, "XML": TokenType.XML, @@ -755,6 +756,7 @@ class TSQL(Dialect): exp.DataType.Type.TIMESTAMP: "DATETIME2", exp.DataType.Type.TIMESTAMPTZ: "DATETIMEOFFSET", exp.DataType.Type.VARIANT: "SQL_VARIANT", + exp.DataType.Type.ROWVERSION: "ROWVERSION", } TYPE_MAPPING.pop(exp.DataType.Type.NCHAR) @@ -1052,3 +1054,9 @@ class TSQL(Dialect): 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: + action = seq_get(expression.args.get("actions") or [], 0) + if isinstance(action, exp.RenameTable): + return f"EXEC sp_rename '{self.sql(expression.this)}', '{action.this.name}'" + return super().altertable_sql(expression) |