/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 vote273 views1 answer
Mysql collation portugues brasil
SQL
0 vote221 views1 answer
R dbConnect(odbc::odbc() to ms sql server remote
SQL
1 vote174 views1 answer
Set all the vluses in calumn in sql to false
SQL
0 vote175 views1 answer
Sql check for null and empty string
SQL
0 vote202 views1 answer
Format the money fied with comma in international system using sql
SQL
0 vote173 views1 answer
Lost connection to MySQL server during query when dumping table
SQL
2 votes179 views2 answers
TSQL GET ALL COLUMNS IN TABLE
SQL
0 vote181 views1 answer
Power query datetime to date
SQL
0 vote290 views1 answer
Mysql edit trigger
SQL
2 votes169 views1 answer
Update with join sql server
SQL