azuredatastudio icon indicating copy to clipboard operation
azuredatastudio copied to clipboard

Add SQL Code formatting, And suggestions for table joins

Open yitzchokneuhaus1 opened this issue 6 years ago • 2 comments

  • SQL Operations Studio Version: Latest

Steps to Reproduce: It would be very helpful if we can get a Command to format a complex script. Also When writing Large queries it is nice if the editor would suggest table and column joins based on a priority

yitzchokneuhaus1 avatar Mar 18 '18 13:03 yitzchokneuhaus1

@yitzchokneuhaus1 have you tried the Format Selection or Format Document commands for formating (available in the context menu for example)?

We've discussed adding JOIN suggestions to the intellisense recommendations. This is a really useful feature that is available in several other SQL editors that we'd also like to provide.

kburtram avatar Mar 19 '18 17:03 kburtram

Well, Format Document work's poorly with more complex structures (at least inside Crete/Alter procedure statements).

I'm not sure if you are aware of that - I can give some examples if needed.

pmduda avatar May 15 '18 12:05 pmduda