Author Topic: SQL Beautifier  (Read 8877 times)

NateTut

  • Junior Community Member
  • Posts: 5
  • Hero Points: 0
SQL Beautifier
« on: August 13, 2008, 02:37:34 pm »
I've done some searching but I couldn't find any examples of a SQL beautifier macro. Has anyone got one that they'd be willing to share?

Thanks!

 ;D

srouleau

  • Community Member
  • Posts: 67
  • Hero Points: 4
Re: SQL Beautifier
« Reply #1 on: August 13, 2008, 04:26:34 pm »
Such a thing would indeed be quite great to have within VS.

Meanwhile I use http://www.sqlinform.com/ which is free; there's an online version, or you can download the .jar file and run it locally.

Sorry for the plug, couldn't resist -- been happy with this freeware and I keep going back to it.

Steph

NateTut

  • Junior Community Member
  • Posts: 5
  • Hero Points: 0
Re: SQL Beautifier
« Reply #2 on: August 13, 2008, 08:24:50 pm »
Thanks. I like SQLInform, but it doesn't support my database (Teradata) and there's more formatting that I'd like to do.

guidomarcel

  • Junior Community Member
  • Posts: 2
  • Hero Points: 0
Re: SQL Beautifier
« Reply #3 on: August 23, 2008, 04:53:45 pm »
Hi,
when you tell me the missing rules in SQLinForm, then I can add them.
Regards
Guido
www.sqlinform.com

damaha

  • New Community Member
  • Posts: 1
  • Hero Points: 0
Re: SQL Beautifier
« Reply #4 on: August 24, 2008, 02:41:28 am »
I always use this free online sql formatter, save me lots of time.

http://www.wangz.net/gsqlparser/sqlpp/sqlformat.htm

guidomarcel

  • Junior Community Member
  • Posts: 2
  • Hero Points: 0
Re: SQL Beautifier
« Reply #5 on: August 24, 2008, 12:14:53 pm »
Hi damaha,
can your formatter handle Teradata specific syntax rules?
Regards
Guido
« Last Edit: August 24, 2008, 05:11:30 pm by guidomarcel »