How can we help you today? How can we help you today?

Format SQL does not format a CREATE TYPE statement

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.
wsoranno
0

Comments

1 comment

Sort by
  • 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.
    Anu D
    0

Add comment

Please sign in to leave a comment.