/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

23 votes112 views3 answers
Sql where contains part of string
SQL
1 vote99 views1 answer
Add constraint sql
SQL
0 vote106 views1 answer
Oracle sql date summer time
SQL
3 votes226 views1 answer
Alembic.util.exc.CommandError: Target database is not up to date.
SQL
12 votes98 views4 answers
Mysql version
SQL
0 vote105 views1 answer
Oracle shrink table
SQL
0 vote100 views1 answer
SQL Query Orderby Two or More Columns and by number of characters
SQL
0 vote109 views1 answer
Sql server select top 2 of each group
SQL
10 votes110 views1 answer
Oracle dependencies table
SQL
9 votes131 views3 answers
Date format in sql
SQL