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

24 votes107 views5 answers
Sql reset auto increment
SQL
1 vote99 views1 answer
Postgresql must appear in the group by clause or be used in an aggregate function
SQL
0 vote110 views1 answer
Change role postgres
SQL
0 vote118 views1 answer
Sql get year from datetime field
SQL
0 vote112 views1 answer
How to use sqlcommand
SQL
0 vote110 views1 answer
GROUP BY postgres
SQL
2 votes112 views1 answer
Oracle table size
SQL
0 vote103 views1 answer
Psql check if value in array
SQL
7 votes103 views3 answers
SQL create a new table
SQL
0 vote123 views2 answers
Starts and end with vowel sql
SQL