To Identify Available SQL Data Types

Written by

Here, we are going to see what are the available datatypes in SQL and how to identify those.

What are Available SQL Data Types?

Available SQL Datatypes

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;

Image Pic

To Identify Available System Data Types

SQL Script to identify Available User-Defined Data Types

SELECT * FROM sys.types where is_user_defined=1;

Image Pic

To Identify Available User-Defined Data Types

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.

Thanks for reading and Follow Blog!

Here, we are going to see what are the available datatypes in SQL and how to identify those. What are Available SQL Data Types? Available SQL Datatypes 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; Image Pic To Identify Available System Data Types SQL Script to identify Available User-Defined Data Types SELECT * FROM sys.types where is_user_defined=1; Image Pic To Identify Available User-Defined Data Types 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. Thanks for reading and Follow Blog!

User Rating: Be the first one !
0
Article Categories:
SQL Server

Leave a Reply

Your email address will not be published. Required fields are marked *

Shares