/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

29 votes299 views6 answers
Delete all rows from table mysql
SQL
16 votes324 views3 answers
Update table from another table
SQL
3 votes342 views3 answers
Illuminate database queryexception could not find driver (sql select * from
SQL
-1 vote298 views3 answers
Psql get last rows
SQL
1 vote301 views1 answer
Import sql file mysql commadn line
SQL
4 votes312 views4 answers
Oracle tablespace tables list
SQL
1 vote305 views2 answers
How to add amount between date in sql
SQL
0 vote302 views1 answer
Regex mongoose
SQL
-1 vote329 views5 answers
Not in sql
SQL
10 votes297 views4 answers
Fetch first 5 characters of the string in sql
SQL