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 vote285 views1 answer
Sql min
SQL
0 vote290 views1 answer
Sql query to select records entered in last 24 hours
SQL
0 vote315 views1 answer
How much space does sql server take per row
SQL
0 vote321 views1 answer
Select all same column value in sql
SQL
23 votes303 views4 answers
How to uninstall postgresql in ubuntu
SQL
2 votes646 views1 answer
Oracle virtual column
SQL
2 votes326 views3 answers
Row number mssql
SQL
0 vote299 views1 answer
Oracle merge insert if not exists
SQL
0 vote307 views1 answer
Start and stop mysql
SQL
3 votes285 views1 answer
Mysql UPDate with enner join
SQL