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 vote232 views1 answer
Oracle temporary table
SQL
0 vote187 views1 answer
Oracle procedure teamplate
SQL
0 vote180 views1 answer
Run postgresql dump to csv
SQL
-2 votes234 views1 answer
Trunc in sql
SQL
0 vote192 views1 answer
Mysql error 1251
SQL
19 votes184 views6 answers
What is mySQL
SQL
0 vote184 views1 answer
Create table database in psql
SQL
3 votes205 views3 answers
Update con select postgresql
SQL
0 vote176 views1 answer
Oarcale list objects
SQL
0 vote184 views1 answer
Get last date join sql
SQL