Options
Partition function
torsten.strauss
Friend of Redgate › Posts: 266 Silver 3
in SQL Prompt
Hi Redgate Team,
SQL Prompt will add an additional space before the data type which is not needed.
Thanks for fixing!
Torsten
MVP
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
Tagged:
Answers
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
Kind regards
Dan Calver | Redgate Software
Have you visited our Help Center?
there are two spaces...
I'm only getting one space when formatting the SQL using your script style and the default.
Thanks,
Dan
Kind regards
Dan Calver | Redgate Software
Have you visited our Help Center?
I can see two spaces ....