/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

0 vote330 views1 answer
Select password from user mysql
SQL
0 vote347 views1 answer
Install squirrel sql ubuntu
SQL
0 vote363 views1 answer
What alter does in db
SQL
0 vote379 views1 answer
Mysql url
SQL
0 vote496 views1 answer
ORA-01400
SQL
0 vote332 views4 answers
Sql year
SQL
0 vote357 views1 answer
Mysql join table with a text columns with ids splited by char
SQL
0 vote325 views1 answer
Grant access on table in oracle
SQL
1 vote352 views1 answer
Mysql data from file
SQL
0 vote359 views2 answers
Postgres having
SQL