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.