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

3 votes337 views1 answer
Sql replace character in string in all records
SQL
0 vote343 views1 answer
Get date from timestamp in mysql
SQL
0 vote327 views1 answer
Mysql select where field is a value
SQL
0 vote372 views1 answer
Dataframe lambda elif
SQL
0 vote329 views1 answer
Adding conditions in MERGE statement in Oracle SQL for INSERT/UPDATE
SQL
3 votes394 views2 answers
Wp do sql query from function
SQL
1 vote312 views1 answer
Mysql column start with string
SQL
0 vote364 views1 answer
Select distinct after join
SQL
0 vote338 views1 answer
Port 5432 is already in use Usually this means that there is already a PostgreSQL server running on your Mac. If you want to run multiple servers simultaneously, use different ports.
SQL
0 vote331 views2 answers
How to create a table from another table in sql derby
SQL