Format SQL does not format a CREATE TYPE statement

wsoranno

The command to format sql ignores the CREATE TYPE statement.
If I type the following:

CREATE TYPE dbo.test AS TABLE (
clm1 VARCHAR(2), clm2 INT, clm3 INT, clm4 INT )

and choose to format it. Nothing happens.

I would expect it to format the code as if it were a CREATE TABLE statement like the following:

CREATE TABLE dbo.test
    (
     clm1 VARCHAR(2)
    ,clm2 INT
    ,clm3 INT
    ,clm4 INT
    )

I have SQL Prompt Pro 5.1.6.35 installed.
This behavior is happening in SSMS.

If I change the create statement to a CREATE TABLE to do the formating and then change it back to CREATE TYPE. Choosing to format will left justify everything in the statement.

Anu D

Many thanks for your post and apologies for inconvenience caused.

We appreciate your feedback and hence logged this as a feature request in our internal tracking system whose tracking id is SP-3989.

It will be reviewed by product manager and than marked for the future release.

I will update you as soon as it is incorporated.