/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

8 votes117 views1 answer
Unique vs primary key
SQL
7 votes121 views3 answers
Sql update where id
SQL
1 vote125 views1 answer
Sql server cast date dd/mm/yyyy
SQL
0 vote136 views1 answer
Insert into Select * - NAYCode.com
SQL
2 votes143 views1 answer
Install postgresql centos 5
SQL
3 votes121 views1 answer
Oracle revoke grant
SQL
1 vote143 views1 answer
Varchar plsql
SQL
0 vote125 views1 answer
How to output a different column name in mysql
SQL
0 vote132 views1 answer
T sql check active deadlock
SQL
3 votes122 views1 answer
Sql replace character in string in all records
SQL