/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

0 vote172 views1 answer
Value of sold product using having and group by in sql
SQL
2 votes157 views2 answers
Oracle create table if not exists
SQL
0 vote197 views1 answer
Login failed for user sql server
SQL
1 vote180 views2 answers
How to combine 2 tables in MySQL
SQL
0 vote161 views2 answers
Update information in a mysql column
SQL
0 vote174 views1 answer
Convert excel into sqllite db using python
SQL
4 votes178 views1 answer
Adding data to table in sql python
SQL
3 votes113 views1 answer
How to get list of synonyms in oracle
SQL
3 votes175 views1 answer
Sql replace character in string in all records
SQL
4 votes182 views2 answers
What is table in sql
SQL