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 vote198 views1 answer
Trim leading zeros in sql
SQL
0 vote179 views1 answer
Sql join on a subquery
SQL
0 vote181 views1 answer
Oracle dynamic select into
SQL
14 votes180 views3 answers
Delete all records from table except sql
SQL
10 votes180 views2 answers
Tsql merge example
SQL
0 vote189 views1 answer
Query to get all primary keys and foreign key
SQL
1 vote191 views1 answer
Mysql select from outside
SQL
0 vote190 views1 answer
How to select a row in sql
SQL
0 vote175 views1 answer
Automate mysql cli query
SQL
6 votes211 views2 answers
Clear a table in mysql
SQL