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 vote185 views1 answer
Update top 100 sql
SQL
0 vote185 views1 answer
10000000000000000000 am to meters
SQL
0 vote200 views1 answer
Where field is null sql knex
SQL
18 votes197 views3 answers
Find column name in database
SQL
8 votes199 views2 answers
Oracle auto increment primary key
SQL
0 vote215 views1 answer
Default order by in mysql
SQL
2 votes206 views1 answer
Q operator in plsql
SQL
0 vote202 views2 answers
Collation in sql
SQL
1 vote188 views1 answer
Mysql sort by date column
SQL
57 votes336 views5 answers
How to create a new user in postgresql
SQL