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

1 vote224 views1 answer
OSError: mysql_config not found
SQL
0 vote272 views1 answer
Sql delete row from table where id
SQL
2 votes244 views2 answers
Postgres drop column if exists
SQL
0 vote219 views1 answer
Delete first row in sql
SQL
3 votes248 views2 answers
Wp do sql query from function
SQL
0 vote173 views1 answer
Alter table add foreign key mariadb example
SQL
-1 vote132 views2 answers
Datetime sql server week
SQL
5 votes205 views1 answer
Mysql select greater than yesterday
SQL
13 votes266 views4 answers
Mysql remove foreign key constraint
SQL
2 votes190 views3 answers
How to pass password mysql command line
SQL