Checking 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

3 votes179 views2 answers
Truncate table
SQL
0 vote168 views1 answer
What is SQL data store?
SQL
23 votes181 views6 answers
Create table sql server
SQL
0 vote219 views1 answer
Sql set data from a select query to a temp table and insert
SQL
0 vote120 views2 answers
Denormalization in sql
SQL
3 votes154 views1 answer
Sql select all
SQL
8 votes169 views2 answers
Replace string value in sql
SQL
3 votes170 views1 answer
Sql is not like
SQL
3 votes170 views1 answer
Stpop start psql server
SQL
4 votes211 views1 answer
Rename stored procedure in sql server
SQL