Tag: database

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 Databases in MSSQL you can use the following snippet. Sample MSSQL SQL Server Version newer than MS SQL 2000 also support these StoredProcedures. or

This snippet will allow you to use the OpenIfClosed DBConnection extension method for C# and VB.NET. Sample C# Sample VB.NET

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

To show all backups of a Database in MSSQL you can use the following snippet. This snippet will show you every path even if the backup does not exist anymore.…

To list last backup date of all databases in MSSQL you can use the following snippet. Sample MSSQL