Checking 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 vote286 views1 answer
How to pass list as parameter in SQL query
SQL
1 vote265 views1 answer
Spring postgresql reset auto increment to 0
SQL
0 vote255 views1 answer
Mysql sql select one day before
SQL
11 votes257 views2 answers
Having in sql
SQL
0 vote267 views1 answer
Sql delete from with relation
SQL
-1 vote258 views2 answers
Sql convert date to string yyyy-mm-dd
SQL
7 votes259 views1 answer
Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column. To disable safe mode, toggle the option in Preferences -> SQL Editor and reconnect.
SQL
0 vote254 views1 answer
Unique index in mysql
SQL
0 vote277 views1 answer
Compare subqueries oracle
SQL
0 vote273 views1 answer
Sql out file formate
SQL