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 vote150 views1 answer
Drop function
SQL
0 vote171 views1 answer
Merge clause with inner join
SQL
4 votes182 views2 answers
Oracle unliock account
SQL
24 votes167 views4 answers
Mysql datetime
SQL
0 vote151 views1 answer
Sql find all different values in column
SQL
-1 vote144 views1 answer
Search all tables all columns for a specific value in mssql-server
SQL
0 vote118 views1 answer
Mysql insert with foreign key
SQL
2 votes159 views1 answer
Postgresql create table as select
SQL
1 vote143 views1 answer
Woocommerce mysql price table
SQL
8 votes168 views1 answer
Mysql restore database
SQL