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

BUG : Script Table / Partition scheme syntax error and missing in index definition

Hi Redgate Team,

Hovering over a partitioned table, SQL Prompt does not add the partition column to the partition scheme which causes a syntax error. Also, no aligned index includes the partition scheme which is wrong as well. 
Would be great to see a fix in the next release - thanks.

Example /result of a partitioned table and aligned index

CREATE TABLE dbo.Transactions
(
col1 int NOT NULL
  , col2 int NOT NULL
  , DateTime datetime2(2) NOT NULL
) ON ps_DateTime;  --- missing the partition column


CREATE NONCLUSTERED INDEX NCL_Transactions_Ccol2
ON dbo.Transactions (
col2
  , DateTime
);   --- missing the partition scheme and column
GO

Torsten 
MVP

Answers

Sign In or Register to comment.