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 vote213 views1 answer
Sql find column name like
SQL
1 vote220 views1 answer
Update from select join
SQL
0 vote223 views1 answer
Mysql select inside sum
SQL
0 vote230 views1 answer
Sql server pivot rows to columns
SQL
0 vote256 views2 answers
Dbms interview questions
SQL
16 votes252 views3 answers
Order by sql query
SQL
21 votes246 views3 answers
Sql server search column name in all tables
SQL
3 votes243 views1 answer
Ms sql skip take
SQL
3 votes209 views1 answer
Sql print all names that start with a given letter
SQL
-1 vote213 views1 answer
Sql select data from one database and insert into a different database
SQL