/SQL/How to check 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 vote242 views1 answer
How to make full text search dynamic in mysql
SQL
1 vote239 views1 answer
Error code 1175 mysql fix
SQL
1 vote218 views1 answer
Oracle current sequence value
SQL
1 vote236 views1 answer
Sqlite3 read only
SQL
0 vote246 views1 answer
Symfony\Component\Debug\Exception\FatalThrowableError : Class 'Doctrine\DBAL\Driver\PDOSqlite\Driver' not found
SQL
3 votes269 views4 answers
Truncate syntax in sql
SQL
0 vote265 views1 answer
Primary key start from number
SQL
0 vote249 views1 answer
ACCEPT nome PROMPT on oracle
SQL
2 votes226 views1 answer
Oracle list grants on procedure
SQL
0 vote210 views1 answer
Procedures and functions in pl/sql
SQL