How can we help you today? How can we help you today?

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!
torsten.strauss
0

Comments

1 comment

Sort by
  • 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!
    Tianjiao_Li
    0

Add comment

Please sign in to leave a comment.