/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

1 vote301 views1 answer
Mysql select utc time in eastern time
SQL
1 vote282 views2 answers
Show sql logs in spring boot
SQL
1 vote367 views1 answer
Postgres see sequence current state
SQL
1 vote330 views1 answer
Too many connections mysql
SQL
0 vote308 views1 answer
Replace sqlalchemy
SQL
0 vote342 views1 answer
Oracle drop type
SQL
0 vote353 views1 answer
Oracle string length
SQL
2 votes280 views4 answers
Mysql change database character set to utf8mb4
SQL
1 vote334 views2 answers
Mysql allow remote connections
SQL
1 vote314 views1 answer
Oracle explain plan
SQL