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

5 votes116 views5 answers
Find max number in sql
SQL
0 vote126 views1 answer
MySQL import data from large CSV file
SQL
1 vote127 views3 answers
Mysql parse int
SQL
0 vote100 views1 answer
Call to undefined function mysql_query() in D:\xampp\htdocs\image\index.php:11 Stack trace: #0 {main} thrown in site:stackoverflow.com
SQL
1 vote114 views1 answer
Psql autocomplete for mac brew install
SQL
0 vote113 views1 answer
How to user id to show in from date to upto date in mssql server
SQL
0 vote114 views1 answer
Oracle sql winter time change
SQL
0 vote118 views1 answer
Kill slow queries mysql
SQL
0 vote168 views1 answer
Delete from IN subquery
SQL
3 votes120 views2 answers
How to modify rows in SQL Server
SQL