Bug / DATA_COMPRESSION

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!

Answers

Sign In or Register to comment.