/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 vote301 views1 answer
1 column values in to 1 single row in sql
SQL
8 votes293 views1 answer
Oracle find text in functions
SQL
1 vote311 views1 answer
Importance of comment in mysql
SQL
0 vote345 views1 answer
Oracle list user locked
SQL
0 vote328 views1 answer
Clear query cache sql server
SQL
0 vote361 views1 answer
Stratified sampling sql
SQL
0 vote310 views1 answer
Import sql dump into postgresql database
SQL
0 vote333 views3 answers
How to increase size of column in sql
SQL
2 votes334 views2 answers
Convert_tz mysql
SQL
23 votes347 views6 answers
Create table sql server
SQL