/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 vote255 views1 answer
Caused by: java.lang.IllegalStateException: Cannot load driver class: com.mysql.jdbc.Driver
SQL
0 vote288 views1 answer
Mengatasi error mysqldump: [ERROR] unknown option '--no-beep'
SQL
4 votes228 views2 answers
Select todays data postgres query
SQL
24 votes256 views5 answers
Sql server insert into select
SQL
5 votes240 views1 answer
Oracle list packages
SQL
0 vote263 views1 answer
Select amount weeks between two dates mysql
SQL
11 votes282 views2 answers
Having clause in sql
SQL
2 votes236 views1 answer
Node and mysql like
SQL
1 vote250 views1 answer
Xampp import sql file command line
SQL
1 vote271 views1 answer
Oracle truncate partition
SQL