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

24 votes127 views6 answers
Sql change table name
SQL
0 vote136 views1 answer
Create a sql server database programmatically
SQL
3 votes165 views2 answers
@sqlresultsetmapping
SQL
11 votes143 views1 answer
Oracle export view ddl
SQL
0 vote141 views1 answer
Remove transient options sql wordpress
SQL
0 vote129 views1 answer
Where date major today mysql
SQL
3 votes139 views2 answers
Postgresql select all column names
SQL
1 vote119 views1 answer
Moodle query item quiz
SQL
3 votes120 views1 answer
Oracle revoke grant
SQL
0 vote131 views1 answer
Take sql dump in to file
SQL