/SQL/How to check 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

2 votes221 views4 answers
Sql query interview questions
SQL
0 vote212 views1 answer
Como hacer una consulta en sql
SQL
1 vote234 views1 answer
Round one decimal place mysql
SQL
1 vote203 views1 answer
Clear screen command in psql
SQL
0 vote227 views1 answer
Create table as select sql server error
SQL
0 vote206 views1 answer
Update one column from another column in same table
SQL
0 vote222 views2 answers
Create-toys-table-with-toy_name-column
SQL
0 vote212 views1 answer
Mysql return column names when table is empty
SQL
4 votes258 views1 answer
Ms sql truncate table vs delete
SQL
0 vote210 views1 answer
Soql last week
SQL