Programming

When working with SQL data and lots of foreign keys, you may have the need to drop everything. Well I have just the right SQL statement for you. The following statement will drop everything the given database, including the following: non-system stored procedures views functions foreign key constraints primary key constraints tables You can execute parts of the script on its own if you only want to drop a certain part....

Windows Subsystem for Linux (WSL) behind Proxy Recently I came accross the issue of wanting to install apt packages in WSL behind a corporate proxy. Plus I wanted to update my yarn package by using curl -o- -L https://yarnpkg.com/install.sh | bash which also needs to go through the proxy. The solution is the same as if we want to set the proxy in a standard Ubuntu. So simply create a proxy....