Partition function

torsten.strauss

Hi Redgate Team,

SQL Prompt will add an additional space before the data type which is not needed.

Thanks for fixing!

Torsten
MVP

-- Create a partition function

CREATE PARTITION FUNCTION pf  (date)  -- pf__(date)

AS RANGE LEFT FOR VALUES

(

'20090101'

  , '20100101'

  , '20110101'

  , '20120101'

  , '20130101'

  , '20140101'

  , '20150101'

  , '20160101'

  , '20170101'

  , '20180101'

  , '20190101'

);

GO

DanC

Hi Tortsten,

Thank you for reporting this to us!

This doesn't seem to be a bug as having a space before the datatype seems to be the typical way of styling this (e.g., the examples on Microsoft's docs page: https://docs.microsoft.com/en-us/sql/t-sql/statements/create-partition-function-transact-sql?view=sql-server-ver15).

However if you wish to remove the space then please submit a feature request on the UserVoice forum.

I hope this has been helpful,
Dan

torsten.strauss

Hi Dan,

there are two spaces...

DanC

Hi Torsten,

I'm only getting one space when formatting the SQL using your script style and the default.

Thanks,
Dan

torsten.strauss

Hi Dan,

I can see two spaces ....