/SQL/How to check 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

5 votes113 views2 answers
Mysqldump password
SQL
2 votes110 views1 answer
Insert from table tsql
SQL
0 vote144 views1 answer
Suhaib
SQL
0 vote122 views1 answer
Oracle select partition
SQL
1 vote128 views1 answer
Oracle stop
SQL
1 vote123 views1 answer
Postgres delete from where date is greater than specific date
SQL
1 vote117 views1 answer
Replace all numbers in mysql
SQL
-2 votes107 views1 answer
How to open database
SQL
0 vote137 views1 answer
Sql today at midnight
SQL
0 vote123 views1 answer
Mysql workbench procedure
SQL