有没有重构SQL的工具，有点像SQL的ReSharper [英] Is there a tool for refactoring SQL, a bit like a ReSharper for SQL

问题描述

我现在追求的东西非常基础:

The sort of stuff I'm after right now is quite basic:

• 自动格式化
• 检测未使用的变量
• 变量命名约定检查

如果有一种工具可以处理更复杂的重构，例如在 重构数据库，但我理解当前数据库结构和数据状态引入的额外复杂性可能会阻止其中的许多.

I wouldn't be surprised if there was a tool available that could handle more complex refactorings such as those found in Refactoring Databases, but I appreciate that the added complexities introduced by current db structure and data state may prevent many of them.

我想我在追求 ReSQLer

I suppose I'm after ReSQLer

推荐答案

JetBrains 刚刚发布了 0xDBE - 一种用于 SQL 机器的新 IDE.

JetBrains have just announced 0xDBE - a new IDE for SQL machines.

它构建在 IntelliJ 平台上，因此应该具有许多与您在 JetBrains 产品套件中获得的相同的快捷方式.

It's build on the IntelliJ platform, so should have many of the same shortcuts you get in the JetBrains suite of products.

http://www.jetbrains.com/dbe/

这篇关于有没有重构SQL的工具，有点像SQL的ReSharper的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！