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 ?