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 vote150 views1 answer
Pl sql join 3 tables
SQL
0 vote153 views2 answers
Laravel: customize or extend notifications - database model
SQL
2 votes157 views2 answers
Sql query to list all tables in a database sql server
SQL
-1 vote171 views1 answer
SQL SERVER microsoft How to Add Column at Specific Location in Table
SQL
4 votes159 views2 answers
Float postgres
SQL
3 votes150 views2 answers
SqlMessage: "Host '192.168.64.1' is not allowed to connect to this MariaDB server
SQL
5 votes144 views1 answer
Oracle ORA-00054 origin
SQL
0 vote123 views1 answer
Login phpmyadmin without password
SQL
0 vote141 views1 answer
What is the essence of SQL?
SQL
3 votes137 views1 answer
Postgresql if null then 0
SQL