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 vote126 views1 answer
Mysql calculated column
SQL
0 vote130 views2 answers
Csv into data postgres
SQL
0 vote125 views1 answer
10000000000000000000 am to meters
SQL
7 votes138 views1 answer
Buy forge mods server hosting
SQL
0 vote141 views3 answers
How to assign custom id in mysql
SQL
1 vote122 views1 answer
Sql alchemy with azuresql server
SQL
3 votes124 views2 answers
Oracle sql select all days between two dates except weekends
SQL
0 vote134 views1 answer
Left join in codeigniter query builder
SQL
5 votes130 views3 answers
How to remove unique key constraint in mysql
SQL
0 vote126 views1 answer
Allow all local clients (local socket connections) to connect to the kodekloud_db1
SQL