Maximize the power of SQL Prompt with SQL Toolbelt Essentials. Watch now.

Partition function

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

Answers

Sign In or Register to comment.