/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

8 votes316 views1 answer
Racle create auto increment column
SQL
0 vote305 views1 answer
Call scalar valued function sql
SQL
0 vote288 views2 answers
How to type a blank discord messgae
SQL
0 vote279 views1 answer
Check mysql password with docker container magento 2
SQL
0 vote314 views5 answers
ABC TO FLEX BATTLE IM POOR
SQL
0 vote295 views1 answer
Replace string in whole database mysql stackoverflow
SQL
0 vote285 views1 answer
Check duplicate values plsql
SQL
14 votes290 views3 answers
SQL trim
SQL
0 vote288 views1 answer
Bus source and destination equal to destination and source of another by sql query
SQL
0 vote310 views1 answer
Group by 15 minute interval sql server
SQL