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 votes136 views2 answers
Sql query to list all tables in a database sql server
SQL
0 vote133 views1 answer
Sql datediff db2
SQL
0 vote140 views1 answer
Mysql filter based on datediff
SQL
0 vote126 views1 answer
What is initial catalog in sql connection string
SQL
0 vote121 views1 answer
Sql examples from your work
SQL
0 vote174 views1 answer
Postgres docs /copy metacomand
SQL
1 vote130 views1 answer
Customer using hdfc bank sql query
SQL
1 vote146 views1 answer
Sql first day quarter
SQL
1 vote133 views1 answer
Database Queries
SQL
0 vote173 views1 answer
Mysl like insert a variable
SQL