/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

6 votes329 views2 answers
Mysql version check cmd
SQL
0 vote367 views1 answer
.sql File Run in PSQL
SQL
0 vote312 views1 answer
Drop check command
SQL
10 votes358 views2 answers
Oracle alter sequence nextval
SQL
0 vote333 views1 answer
Utiliser sql ligne de commande
SQL
0 vote339 views1 answer
Mysql count unique in group statement
SQL
1 vote346 views1 answer
Sql in array query
SQL
0 vote352 views1 answer
Sql order by except one row
SQL
0 vote332 views1 answer
Convert .mdf to .bak
SQL
0 vote329 views1 answer
Exclude last comma separated string mysql
SQL