/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

2 votes144 views1 answer
Datetrunc
SQL
0 vote133 views1 answer
Sql random decimal
SQL
0 vote155 views1 answer
How to find total working hour in sql
SQL
1 vote114 views5 answers
Spring boot sql logging
SQL
1 vote142 views1 answer
Expression number 1 of select list is not in group by clause
SQL
0 vote143 views1 answer
Sql last 7 days
SQL
-1 vote135 views1 answer
Search all tables all columns for a specific value in mssql-server
SQL
1 vote159 views1 answer
T-SQL / AZURE Reseed
SQL
0 vote138 views1 answer
MySQLdb._exceptions.ProgrammingError: (1146, "Table 'edxapp.app_feedback feedback category' doesn't exist")
SQL
3 votes168 views3 answers
Start postgresql ubuntu
SQL