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

1 vote359 views1 answer
Drop column if exists sql server
SQL
0 vote342 views1 answer
Mysql count by month
SQL
1 vote355 views1 answer
Psql search table
SQL
0 vote340 views1 answer
Plpgsql coalesce equivalent for empty string
SQL
0 vote372 views1 answer
Cannot pip install mysqlclient
SQL
0 vote341 views1 answer
T sql less than date
SQL
5 votes366 views3 answers
Db begintransaction laravel
SQL
6 votes357 views2 answers
Mysql interval 1 day
SQL
1 vote351 views1 answer
Vagrant mysql downgrade version
SQL
0 vote340 views1 answer
We are intrested to work with your organization
SQL