Sql

SELECT DATA_TYPE 
FROM INFORMATION_SCHEMA.COLUMNS
WHERE 
     TABLE_NAME = 'yourTableName' AND 
     COLUMN_NAME = 'yourColumnName'

PREVIOUS	NEXT

Code Example
Sql :: python mysql select
Sql :: show databases mysql docker
Sql :: update mysql centos
Sql :: mysql select greater than yesterday
Sql :: get table column names sql ssms
Sql :: sql drop multiple columns if exists
Sql :: how to alter table name in mysql
Sql :: mysql password error create datbase
Sql :: node and mysql like
Sql :: alert table name mysql
Sql :: sqlite show columns in table
Sql :: set statistics on in ssms
Sql :: mysql get count of rows
Sql :: sql command to find foreign key references
Sql :: convert float to int sql
Sql :: mysql on terminal mac
Sql :: oracle scan source ddl
Sql :: oracle list index on table
Sql :: How to select the nth row in a SQL database table?
Sql :: check mysql version phpmyadmin
Sql :: oracle view ddl
Sql :: mysql case when null
Sql :: mysql substract count and distinct count
Sql :: add created and updatedAt fields in mysql
Sql :: delete table sql
Sql :: sql today at midnight
Sql :: sql select only time from datetime
Sql :: mysql trim whitespace
Sql :: show tables sql
Sql :: pl sql asynchronous procedure calls