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

0 vote690 views1 answer
Create pl/sql stored procedure
SQL
1 vote341 views1 answer
How to give access to database in postgresql server to another user
SQL
1 vote362 views1 answer
Jooq convert using gbk
SQL
0 vote364 views2 answers
.... ERROR! The server quit without updating PID file mysql centos
SQL
1 vote362 views1 answer
How to start with sql
SQL
1 vote352 views2 answers
Changes not showing on website server odoo
SQL
0 vote395 views1 answer
Mysqldump: error:
SQL
1 vote397 views1 answer
Find size of all DB's postgres
SQL
0 vote358 views1 answer
How to select an index in oracle sql
SQL
0 vote333 views1 answer
How do i calculate someone's age based on a datetime type birthday?
SQL