/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

5 votes142 views1 answer
Invalid column name sql
SQL
1 vote234 views1 answer
Oracle create program if not exists
SQL
7 votes133 views1 answer
Forge server hosting
SQL
10 votes162 views1 answer
How to import database in mysql by cmd
SQL
0 vote166 views1 answer
Which takes more space in a database a datetime or separate date and time columns?
SQL
2 votes142 views2 answers
Join update query in sql
SQL
2 votes300 views5 answers
Unique in sql server
SQL
31 votes148 views3 answers
Sql count(*)
SQL
8 votes142 views1 answer
Today minus 15 days postgresql
SQL
0 vote141 views1 answer
SQLite3::SQLException: table "categories" already exists: CREATE TABLE "categories" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL
SQL