Announcing a new IDE for PostgreSQL in VS Code

Announcing a new IDE for PostgreSQL in VS Code from Microsoft | Microsoft Community Hub This looks like it could be a decent replacement for azure data studio.

Truncate table

Today I learned that there is a truncate table SQL command that deletes all data from a database table like Delete from but is faster and uses fewer system and transaction log resources. It鈥檚 supported in most database engines but there are likely caveats to keep in mind. For instance, with SQL Server: It will reseed identity columns You can鈥檛 truncate tables that referenced in constraints and it requires ALTER table privileges For clearing out data in lower environments though, I鈥檝e found it useful. ...