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

4 votes224 views3 answers
Sqlite show columns
SQL
0 vote232 views1 answer
Postgres type equivalent to timespan c#
SQL
3 votes224 views2 answers
Oracle apex charging debug
SQL
5 votes236 views2 answers
Oracle list columns
SQL
3 votes244 views2 answers
Update part of a string in mysql
SQL
0 vote237 views1 answer
Mysql récupérer le code création de vue
SQL
0 vote250 views1 answer
Sql: extract day text from datetime value
SQL
0 vote212 views1 answer
How to count null values in sql
SQL
0 vote225 views1 answer
Commit transaction sql
SQL
6 votes181 views2 answers
Generate c# class from sql server table
SQL