/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

1 vote333 views1 answer
Cross schema query oracle 2 users
SQL
0 vote350 views1 answer
Sql remove non numeric characters
SQL
0 vote336 views1 answer
How to reset the database value in SQL server
SQL
-1 vote311 views1 answer
Export mysql table to file
SQL
2 votes339 views2 answers
Mysql alter column default
SQL
10 votes295 views1 answer
Oracle dependency
SQL
1 vote333 views1 answer
Apex ORA-20999
SQL
0 vote339 views1 answer
Mysql 1 hour ago
SQL
0 vote334 views1 answer
Run mysql xampp shell
SQL
-1 vote285 views10 answers
Delete Query in SQL Server
SQL