0

I'm trying to create a table with a default value in MS Access 2016, but I get an error.

I'm trying to create a test table from here

CREATE TABLE dbo.doc_exz 
(
    column_a INT,
    column_b INT DEFAULT 50
);

But after executing the SQL query, I get this error:

Syntax error in CREATE TABLE.

After pressing OK "DEFAUL" selects.

Please, help.

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Ilya
  • 1

0 Answers0