/SQL/How to check 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

3 votes126 views1 answer
Oracle sleep
SQL
0 vote185 views1 answer
Mysql collation portugues brasil
SQL
0 vote146 views1 answer
Show table structure mysql console
SQL
8 votes124 views2 answers
Update sql server from another table
SQL
3 votes133 views1 answer
Sql insert inserted id
SQL
17 votes155 views1 answer
Selecting name that contain certain word in sql
SQL
1 vote131 views1 answer
Postgresql can you have null foreign key
SQL
8 votes158 views1 answer
Insert a select statement into a table
SQL
0 vote125 views1 answer
Assign value to var in SQL
SQL
0 vote126 views1 answer
Sauvegarde complète my sql
SQL