Checking 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

4 votes314 views1 answer
Rename stored procedure in sql server
SQL
0 vote267 views1 answer
Delete double on SQL with multiple primary keys
SQL
0 vote275 views1 answer
Sql select merge multiple values
SQL
0 vote256 views1 answer
What is the essence of SQL?
SQL
3 votes351 views1 answer
Apex call duration
SQL
2 votes261 views1 answer
Insert from table tsql
SQL
0 vote270 views1 answer
Order by with where clause in mysql
SQL
1 vote280 views1 answer
Sample clause in sql
SQL
1 vote282 views1 answer
Sql server datetime vs datetime2
SQL
0 vote278 views2 answers
Sql max count
SQL