Checking data type in sql server

How to check data type in sql server

SELECT DATA_TYPE 
FROM INFORMATION_SCHEMA.COLUMNS
WHERE 
     TABLE_NAME = 'yourTableName' AND 
     COLUMN_NAME = 'yourColumnName'

Checking data type in sql server

SELECT COLUMN_NAME,
       DATA_TYPE,
       IS_NULLABLE,
       CHARACTER_MAXIMUM_LENGTH,
       NUMERIC_PRECISION,
       NUMERIC_SCALE
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME='your_table_name';

Source: bigdata-etl.com

Similar codes

1 vote276 views1 answer
How to delete data from sql database in android
SQL
0 vote251 views1 answer
Mysql workbench download for iinux mint 19.3
SQL
58 votes528 views6 answers
Create new user in postgres
SQL
0 vote258 views1 answer
Sqlite3 update select
SQL
0 vote267 views1 answer
Hibernate xml property MySQL url, username and password
SQL
0 vote280 views1 answer
Load SQLite in Jupyter Notebook together with the access to the file
SQL
-2 votes281 views1 answer
Trunc in sql
SQL
0 vote275 views2 answers
Create-toys-table-with-toy_name-column
SQL
6 votes306 views2 answers
Mysql convert timestamp to date
SQL
2 votes251 views1 answer
Mysql sql add created updated timestamp to existing table
SQL