Search
 
SCRIPT & CODE EXAMPLE
 

SQL

show table columns

-- MySQL
DESCRIBE tableName;
SHOW COLUMNS FROM tableName;

-- SQLite3
.schema tableName
Comment

PREVIOUS NEXT
Code Example
Sql :: mysql cli connect with password 
Sql :: oracle view source 
Sql :: first letter capital in mysql query 
Sql :: mysql show data from table 
Sql :: oracle pl/sql prevent sql injection 
Sql :: date_format for time sql 
Sql :: group by 15 minute interval sql server 
Sql :: inner join just one row 
Sql :: insert random numbers in columns postgress 
Sql :: mysql bigint max value 
Sql :: sql update from select 
Sql :: postgresql create table with boolean column 
Sql :: plsql code for deleting a row from nested table in oracle 
Sql :: woocommerce mysql price table 
Sql :: postgres make sql dump 
Sql :: view linked servers sql 
Sql :: string split in sql server 
Sql :: script to add new column in table sql 
Sql :: return insert results in POSTGRESQL 
Sql :: ora-00054 resource busy and acquire with nowait 
Sql :: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Public Key Retrieval is not allowed 
Sql :: find difference in dates sql 
Sql :: get date from timestamp in mysql 
Sql :: where date major today mysql 
Sql :: mysql user change password 
Sql :: sql display number without decimals 
Sql :: insert a select statement into a table 
Sql :: create database hive 
Sql :: how to get data between a last week in mysql 
Sql :: shrink database file in sql server 
ADD CONTENT
Topic
Content
Source link
Name
6+7 =