/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

1 vote172 views1 answer
How to remove identity from a column in sql server
SQL
11 votes173 views1 answer
Ddl materialized view
SQL
0 vote162 views3 answers
Sql server obtener fecha en formato dd/mm/yyyy
SQL
3 votes192 views2 answers
Mysql import gz
SQL
0 vote166 views1 answer
Não é possível executar uma operação DML dentro de uma consulta
SQL
1 vote179 views1 answer
Get create table query existing table mysql
SQL
0 vote256 views1 answer
ORA-01400
SQL
0 vote170 views1 answer
Sql roll up rows into columns
SQL
0 vote199 views1 answer
Synapse sql table set pk
SQL
1 vote176 views1 answer
Operator does not exist: integer = text
SQL