Sql

SELECT
    column_name,
    data_type
FROM
    information_schema.columns
WHERE
    table_name = 'table_name';

PREVIOUS	NEXT

Code Example
Sql :: oracle insert into
Sql :: postgres check for foreign key
Sql :: oracle convert int to date
Sql :: search for replace in mysql
Sql :: mysql row_number() example
Sql :: how to assign date field for table in mysql
Sql :: postgresql create query
Sql :: mysql update column default value CURRENT_TIMESTAMP error
Sql :: sql compare two tables for differences
Sql :: datediff in sql server
Sql :: add current timestamp in mysql
Sql :: How to convert DateTime to VarChar SQL
Sql :: pad zero sql server
Sql :: sql server rtrim everything after character
Sql :: mysql show all table from database
Sql :: sql select into statement
Sql :: CALCULATING MONTHS BETWEEN TWO DATES IN POSTGRESQL
Sql :: mysql search table in all databases
Sql :: postgre sql create table
Sql :: mariadb mysql root access denied
Sql :: how to generate a unique random number in mysql
Sql :: alter table name sql
Sql :: check if has alpha characters sql
Sql :: drop column from local database postgres pgadmin
Sql :: getdate function in postgresql
Sql :: creating postgresSQL database using the the shell
Sql :: sql server insert into table
Sql :: mysql collation for all languages
Sql :: mysql server not starting in xampp in mac
Sql :: insert into using contant values and source table columns with sql