/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 vote103 views1 answer
How to between in sql
SQL
-1 vote122 views1 answer
Add 10 to all numbers in a column sql
SQL
7 votes135 views2 answers
Mysql Public Key Retrieval is not allowed
SQL
2 votes101 views2 answers
Spring import sql
SQL
0 vote132 views1 answer
Query to insert image
SQL
1 vote121 views1 answer
Encrypt password postgresql
SQL
0 vote128 views1 answer
Sql delete caracter list
SQL
0 vote109 views1 answer
Get role postgres
SQL
0 vote122 views1 answer
Pgadmin save data greyed out
SQL
2 votes110 views2 answers
Select list is not in group by clause
SQL