Default value for bit datatype

You have not mentioned which database engine you are using. Is it SQL Server? If yes, it works as expected if you just remove the word 'column' from statement.

Muhammad Imran Ansari4y ago

At my side, Its working as expected.

You can try the query with values statement like:

ALTER TABLE [dbo].[AttendanceRecord] ADD IsQRScanned5 BIT NOT NULL DEFAULT ('false') WITH VALUES;

Gajendra Jangid4y ago

I had try already this query.

Muhammad Imran Ansari4y ago

Use the following query:

ALTER TABLE tblaspnet_Users ADD IsQRScanned BIT NOT NULL DEFAULT (0)