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

2 votes208 views1 answer
Oracle current date without time
SQL
1 vote227 views2 answers
Duplicate key value violates unique constraint "django_admin_log_pkey"
SQL
1 vote195 views1 answer
Sql week commencing date
SQL
0 vote206 views1 answer
Find and replace database table phpmyadmin
SQL
0 vote215 views1 answer
Sqlalchemy orm duplicate
SQL
5 votes202 views1 answer
Postgresql functions
SQL
1 vote237 views1 answer
Db.Database.SqlQuery
SQL
1 vote229 views1 answer
Connect to mysql database ubuntu
SQL
0 vote218 views1 answer
Sqlite unique multiple columns
SQL
0 vote190 views1 answer
Get only structure database mysql
SQL