/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 vote189 views1 answer
Sql DATE = GETDATE()
SQL
0 vote183 views1 answer
Get first 3 letter of department name in sql
SQL
0 vote241 views1 answer
Sql server query all database objects
SQL
0 vote170 views2 answers
Update all linkedserver tables with openquery on db
SQL
4 votes180 views1 answer
Mysql biginteger size
SQL
0 vote197 views1 answer
Ansi sql count duplicate rows
SQL
0 vote188 views2 answers
How to relationship query two different tables in MySQL
SQL
0 vote184 views1 answer
Sql order by number not ordered
SQL
0 vote174 views1 answer
SQL Server format datetime
SQL
0 vote189 views1 answer
Delete a record from a table sqlite3
SQL