Here, we are going to see what are the available datatypes in SQL and how to identify those.
What are Available SQL Data Types?
To Identify Available SQL DataTypes
We can use sys.types ( System Catalog View) to identify both System and User-Defined Datatypes.
SQL Script to identify Available System Data Types
SELECT * FROM sys.types where is_user_defined=0;
SQL Script to identify Available User-Defined Data Types
SELECT * FROM sys.types where is_user_defined=1;
If you find any datatypes that are missed to mention above, Please comment those.
Thus, we saw the available system and user-defined datatypes in SQL and also the method of identify it. This is applicable for both Azure SQL DB and On-Premises. Unit Tested as well.