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 votes192 views2 answers
Delete all table oracle
SQL
17 votes232 views4 answers
Mysql remove ubuntu
SQL
0 vote167 views2 answers
Sql join on wildcard
SQL
2 votes195 views1 answer
Laravel sql String
SQL
1 vote166 views1 answer
Delete row mssql
SQL
0 vote185 views1 answer
Get id if is not equal in certain table
SQL
0 vote172 views1 answer
Mysql repair a table
SQL
0 vote179 views1 answer
Modifier une valeur sql
SQL
0 vote173 views1 answer
How to increase the width of the screen in oracle
SQL
0 vote211 views1 answer
Sql describe
SQL