/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

3 votes196 views2 answers
How to start mysql in terminal
SQL
14 votes190 views4 answers
Sql compiler
SQL
0 vote179 views1 answer
Sqlite update only if greater
SQL
0 vote194 views1 answer
Excel export from sql using python
SQL
0 vote202 views2 answers
Amazon linux postgresql client
SQL
0 vote186 views2 answers
How to check if a column exists in a SQL Server table?
SQL
14 votes197 views3 answers
Oracle sql limit results
SQL
1 vote209 views1 answer
Tsql random number
SQL
0 vote201 views1 answer
SQLSTATE[01000]: Warning: 1265 Data truncated for column 'job_type' at row 1 (SQL: insert into
SQL
3 votes176 views3 answers
Concatenation in sql
SQL