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

0 vote302 views1 answer
Sqlalchemy get schema from database
SQL
4 votes323 views1 answer
Oracle nls_date_format
SQL
0 vote320 views1 answer
Sql server remove primary key without dropping table
SQL
0 vote276 views1 answer
Oracle query to see what scema i am working in
SQL
1 vote281 views1 answer
Mysql2::Error: Incorrect string value: '\xE2\x80\x8B
SQL
1 vote335 views1 answer
Postgres see sequence current state
SQL
0 vote317 views1 answer
Providername system.data. mysql
SQL
1 vote293 views1 answer
$query = mysqli_query($con, $sql); while ($row = mysqli_fetch_array($query))
SQL
4 votes306 views2 answers
Linq join
SQL
0 vote360 views1 answer
Sqlite schema structure of a relational database
SQL