Lastly, let’s get the data type for the first_name column (under the people table): SELECTĪs you may see, the data type for the first_name column is nvarchar: TABLE_CATALOG Scenario 3 – Get the data type for a specific column For the first two columns (first_name and last_name) the data type is nvarchar, while the data type for the last column (age) is int for integers : TABLE_CATALOG There are 3 columns in the ‘people’ table. In that case, add where TABLE_NAME = ‘people’ at the bottom of the query: SELECT Let’s say that you want to find the data type of the columns under the ‘ people‘ table. Scenario 2 – Get the data type of all columns in a particular table Here is an example of the results that you may get, where the data type of each column is captured under the DATA_TYPE field: TABLE_CATALOG You can then run the following query in order to get the data type of all the columns in the test_database: SELECT

of all columns in a particular databaseģ Scenarios to Get the Data Type of Columns in SQL Server Scenario 1 – Get the data type of all columns in a particular databaseįor example, let’s suppose that you have a database called the ‘ test_database‘ which includes 3 tables.

Next, you’ll see 3 scenarios to get the data type:

You can use the following query to get the data type of your columns in SQL Server: SELECT

Sql server data types