Monday, July 3, 2017

Enable Preview for .SQL file for Windows 10

In File Explorer, Click on View
Then click on Preview Pane

If you click on the SQL file and it says "No Preview Available"
You need to go to Regedit.exe i.e. Registry Editor
Then browse to “Computer\HKEY_CLASSES_ROOT\.sql”

Now

On the right-hand pane, right-click any where and select new string value
Name the new key “PerceivedType” and set the value to “text”

That's it

You should be able to Preview the SQL file in Windows 10