checking data type in sql server

Solutions on MaxInterview for checking data type in sql server by the best coders in the world

showing results for - "checking data type in sql server"
Santino
09 Apr 2020
1SELECT DATA_TYPE 
2FROM INFORMATION_SCHEMA.COLUMNS
3WHERE 
4     TABLE_NAME = 'yourTableName' AND 
5     COLUMN_NAME = 'yourColumnName'
Edwina
06 Nov 2020
1SELECT COLUMN_NAME,
2       DATA_TYPE,
3       IS_NULLABLE,
4       CHARACTER_MAXIMUM_LENGTH,
5       NUMERIC_PRECISION,
6       NUMERIC_SCALE
7FROM INFORMATION_SCHEMA.COLUMNS
8WHERE TABLE_NAME='your_table_name';
queries leading to this page
check the data type in sqlhow to check data type of table in sqlhow to check datatypes in sqlmssql get typehow to determine data type of a data in sql serverhow to check datatype in sqlhow to check the datatype of column in ssmsshow the data type of each column sqlhow to check data types in sqlcheck data type sql serversql show datatype of columnhow to see data type in sqlhow to check the data type in sqlhow to check datatype of table in sqlall data type in sql servernumber data type in sql serverhow to check data types of select query values in sql serverget type in sqlhow to check datatype of value in sqldata type string sqlhow to check data type in sqlcheck datatype of variable sqlhow to find data type in sql serverchecking data type in sql serverget data type in sql serverhow to get column data type from table in sqlsql how do i find out a data type of a column in sqlhow to check the datatype in sqlt sql how to check data type of a variablehow to check table datatype in sql servercheck which type sql serversql see data typesql script to see column data typesget data type of variable sqlsql query type of datasql type of columnscheck what type of data in column sqlhow to identify data type in sqlsql get typeshow to check data type in sql tablesql statement to get column typecheck databse type sqlhow to check column data type in sqlsql how to check data typesql query to get data type of fieldshow to check datatype of value in sql serverhow to find data type in sqlhow to check data type of sql columnhow to check datatype in sql tableget field types from sql tablesql get typefind sql data typehow to see data types in sqlhow to see type of a column in sqlsql type of data checkms sql int data typehow to check the type in ms sqlget sql query typehow to find data types of a column in sqlsql get columns and data typeswhat is the check datatype in sqlhow to check type in sqlhow to check the type of datatype in sqlsql query to check datatype of columnget sql data type of a columnsql server view data typecheck the datatype of a column in sql serversql check dattaypeget data type using sqlget data type sql servercheck data type in sql tablesql server view check data type of columnsql column name datatypesql check typesquery to check data type in sqlcheck data type in sqlsql how to know type of datasql check type of columnsql get type of columnhow to check data type in sql serverget the data type in sqlhow to determine type of sqlnumber in sql server data typehow to check the data type of table sqlhow to know the type of column in sql query commandhow to get data type in sqlnumber datatype in sql serverget type sql serversql check data type of valuechecking data type in sql server