By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE tbl_Country
(
CountryId INT NOT NULL AUTO_INCREMENT,
IsDeleted bit,
PRIMARY KEY (CountryId)
);
INSERT INTO tbl_Country
VALUES (1, 1), (2,0);
Records: 2 Duplicates: 0 Warnings: 0
SELECT * FROM tbl_Country
| CountryId | IsDeleted |
|---|---|
| 1 | 1 |
| 2 | 0 |
ALTER TABLE tbl_Country ALTER COLUMN IsDeleted SET INVISIBLE;
Records: 0 Duplicates: 0 Warnings: 0
SELECT * FROM tbl_Country
| CountryId |
|---|
| 1 |
| 2 |
ALTER TABLE tbl_Country DROP COLUMN IsDeleted;
Records: 0 Duplicates: 0 Warnings: 0
SELECT * FROM tbl_Country
| CountryId |
|---|
| 1 |
| 2 |