/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

7 votes128 views1 answer
Sql server convert string to date
SQL
3 votes146 views2 answers
How to force truncate a table in mysql
SQL
0 vote137 views1 answer
Plsql find location of procedure
SQL
0 vote133 views1 answer
How many columns can be used for creating index?
SQL
-1 vote131 views3 answers
How to restart mysql in linux
SQL
0 vote136 views2 answers
FIND OUT THE NAME HIGHEST SALARY SQL
SQL
3 votes170 views2 answers
Brew restart mysql
SQL
1 vote149 views2 answers
This month mysql where
SQL
5 votes144 views1 answer
Mysql last day of next month
SQL
0 vote132 views1 answer
Mariadb datetime change to microseconds
SQL