We want to migrate a SQL Anywhere database to SQL server 2019. In SQL anywhere we used a lot of domains.
In fact allmost all our columns in the tables refer to domains.
Example of a domain:
create domain CHECKBOX as numeric(1) default 0
check (@column is null or (@column between 0 and 1));
I suppose this domain is the same as a User Defined Data type in SQL Server.
Is it a normal procedure to use User Defined datatypes in SQL server?
What is the sql statement to create the "Domain" checkbox?