/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 votes186 views2 answers
Mysql concatenate two columns into one
SQL
0 vote181 views1 answer
Get who is hired in specific month in sql
SQL
2 votes232 views1 answer
Show max_allowed_packet mysql
SQL
2 votes187 views1 answer
Oracle index size calculation
SQL
0 vote235 views1 answer
Mysql 3 months ago
SQL
2 votes208 views4 answers
2nd highest salary in mysql
SQL
2 votes200 views1 answer
Oracle to_char number format percentage
SQL
0 vote182 views1 answer
Mysql select where text contains
SQL
-2 votes251 views3 answers
How to fetch first 10 rows in sql
SQL
1 vote266 views1 answer
Sqlite create index
SQL