Static analysis
Last updated
Last updated
If your code references objects that are not available in the rest of the database, SQL Tran will warn you via squiggly lines under names referencing something that doesn't exist.
If you hover your mouse pointer over a name, SQL Tran will display what it declares or references.
Pressing F12 when your caret is over a name takes you to the definition of the referenced object. Go To Definition also works by Ctrl+clicking (or Cmd+clicking on Mac) the name.
Source database may have broken references all over the place without anyone realizing how much broken code there is. Objects which aren't used anywhere, or used rarely without anyone logging issues.
You may mark objects ignored and break references in objects depending on them. SQL Tran will warn you about it, but you can still do it.