Bug / DATA_COMPRESSION

torsten.strauss

Hi Redgate Team,

the following valid code cause SQL Prompt to fail.

DROP TABLE IF EXISTS test;

GO

-- Create a table

CREATE TABLE test

(

col1 int NOT NULL

  , col2 int NOT NULL

  , col3 CHAR(100) NOT NULL

DEFAULT ('A')

)

WITH (DATA_COMPRESSION  = PAGE);

GO

Thanks for fixing!

Tianjiao_Li

@torsten.strauss

It appears to format successfully in my test. Could you confirm which version of SSMS and SQL Prompt did you use? What's the error did you see?

Thanks!