Withdata Software provide some tools for MySQL, all these tools can work for MariaDB: See how to use these tools work for MariaDB: Import XML data into MariaDB (MySQL) Schedule and automate MariaDB (MySQL) importing XML data task Import data into MariaDB (MySQL) from MongoDB exported JSON ... Read more
Author Archives: Shiji Pan
Schedule and automate data file converting task
Want to schedule and automate data file format converting task? Using Data File Converter, a desktop tool, you can scheduled data file format converting task easily, just a few mouse clicks! Let computer automate repetitive data file format converting busy work, Data File Converter make our life ... Read more
How to get index column names of a table from Oracle
SELECT i.index_name,c.column_name FROM user_ind_columns c, user_indexes i where c.index_name=i.index_name and c.table_name=i.table_name and i.TABLE_NAME='my_table_name' and i.TABLE_OWNER='my_schema_name' See also: How to get index column names of a table from DB2 How to get index column names of ... Read more
How to get index column names of a table from SQLite
select sql from sqlite_master where tbl_name='my_table_name' and type='index' you can find the index name and column names in ‘sql’ field. See also: How to get index column names of a table from DB2 How to get index column names of a table from SQL Server How to get index column names ... Read more
How to get index column names of a table from PostgreSQL
select i.relname as index_name, a.attname as column_name from pg_class t, pg_class i, pg_index ix, pg_attribute a, pg_namespace n where t.oid = ix.indrelid and i.oid = ix.indexrelid and a.attrelid = t.oid and a.attnum = ANY(ix.indkey) and n.oid=t.relnamespace and t.relkind = 'r' and ... Read more
How to get index column names of a table from MySQL
SELECT INDEX_NAME,COLUMN_NAME FROM INFORMATION_SCHEMA.STATISTICS WHERE TABLE_SCHEMA = 'my_schema_name' AND TABLE_NAME = 'my_table_name' See also: How to get index column names of a table from DB2 How to get index column names of a table from SQL Server How to get index column names of a table ... Read more
How to get index column names of a table from SQL Server
select i.name as IndexName, co.[name] as ColumnName from sys.indexes i join sys.objects o on i.object_id = o.object_id join sys.schemas s on s.schema_id = o.schema_id join sys.index_columns ic on ic.object_id = i.object_id and ic.index_id = i.index_id join sys.columns co on co.object_id = ... Read more
How to get index column names of a table from DB2
select name,colnames from sysibm.sysindexes where tbname='my_table_name' See also: How to get index column names of a table from SQL Server How to get index column names of a table from MySQL How to get index column names of a table from PostgreSQL How to get index column names of a table from ... Read more
How to get primary key of a table from Oracle
SELECT cols.column_name FROM all_constraints cons, all_cons_columns cols WHERE cons.constraint_type = 'P' AND cons.constraint_name = cols.constraint_name AND cons.table_name = cols.table_name AND cons.owner = cols.owner AND cons.table_name='my_table_name' AND cons.owner='my_schema_name' See ... Read more
How to get primary key of a table from DB2
SELECT COLNAME FROM syscat.COLUMNS WHERE tabschema='my_schema_name' AND tabname='my_table_name' AND KEYSEQ=1 See also: How to get primary key of a table from PostgreSQL How to get primary key of a table from SQLite How to get primary key of a table from MySQL How to get primary key of a table ... Read more