Tag: db

To get the size of all tables using MSSQL you can use the snippet below. Sample MSSQL

To check if a Table exists in SQLite you can use the following snippet.

To get a list of all tables in Oracle you can use the following query. if your user does not have sufficient access rights to query dba_tables, you can try…

To change user password in WordPress using MySql you can use the following query. Sample MySql

To delete all pingbacks in WordPress you can use the mysql query below.

To list all views in database in MSSQL you can use the following snippet. Sample MSSQL