What are the challenges you face when working across database platforms? Take the survey
Options

Format SQL does not format a CREATE TYPE statement

wsorannowsoranno Posts: 65
edited June 22, 2011 10:40AM in SQL Prompt Previous Versions
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.
Thanks
Bill Soranno
MCP, MCTS, MCITP DBA
Database Administrator
Winona State University
Maxwell 143
wsoranno@winona.edu

"Quality, like Success, is a Journey, not a Destination" - William Soranno '92

Comments

  • Options
    Anu DAnu D Posts: 876 Silver 3
    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.
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: support@red-gate.com
Sign In or Register to comment.