Author Topic: Trying to beautify TSQL  (Read 4172 times)

AronsonAa

  • Junior Community Member
  • Posts: 3
  • Hero Points: 0
Trying to beautify TSQL
« on: February 21, 2018, 09:19:09 PM »
I know that beautify of SQL is not supported (Been asked for many times), but I wonder if perhaps some segment of beautify can be implemented.  I'm specifically looking to take a selection of lines and format them such that I can use Column Cut/Paste on the selection.

Example:

CREATE TABLE [dbo].[XTEMP](
        [INST] [int] NOT NULL,
        [CUST_NO] [bigint] NOT NULL,
        [EMAIL_ADDR] [varchar](255) NOT NULL,
        [EMAIL_TYPE] [varchar](255) NULL,
        [STATUS] [int] NULL,
        [SRCE] [varchar](255) NULL,
        [LAST_USE] [bigint] NULL,
        [LAST_UPDT] [bigint] NULL,
) ON [PRIMARY]

CREATE TABLE [dbo].[XTemp](
        [INST]                          [int]                     NOT     NULL,
        [CUST_NO]                   [bigint]                 NOT     NULL,
        [EMAIL_ADDR]              [varchar](255)      NOT     NULL,
        [EMAIL_TYPE]               [varchar](255)                  NULL,
        [STATUS]                     [int]                                 NULL,
        [SRCE]                         [varchar](255)                  NULL,
        [LAST_USE]                  [bigint]                             NULL,
        [LAST_UPDT]                [bigint]                             NULL,
) ON [PRIMARY]

Anyone have any thoughts or Macros that will get me close to this ?