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

1 vote288 views3 answers
Date_add mysql
SQL
0 vote227 views1 answer
Java spring boot connect to sql server
SQL
1 vote284 views2 answers
How to combine 2 tables in MySQL
SQL
1 vote292 views1 answer
Print all records of table in mysql
SQL
11 votes295 views2 answers
How to import mysql database command line
SQL
7 votes269 views4 answers
Mysql delete older duplicates
SQL
0 vote284 views1 answer
Close sql query vb.net
SQL
0 vote296 views1 answer
Get primary key of table
SQL
1 vote264 views1 answer
Mysql connect command
SQL
4 votes312 views2 answers
Postgresql float data type
SQL