search

pacoweb / extraSqlScriptAs

Azure Data Studio - 3 "Extra Sql Script As" Extension
MIT License
48 stars 17 forks source link

[Suggestion] Option to remove the database from scripts #24

Open Andrefei opened 2 months ago

Andrefei commented 2 months ago

Hi,

First off, I am really enjoying this extension as it helps making Azure Data Studio usable. Thanks to extensions like this we are slowly but surely transitioning from SSMS to more modern tools 🙌

To the suggestions, what is the reasoning behind including the database name in the script? [db].[schema].[tablename]

This is not the standard in SSMS and at least in my day to day work we have several different environments with the same tables and I find myself using the same queries across different databases.

Could it be an idea to add an option or config where you toggle the database name in the resulting query?

pacoweb commented 2 months ago

Hello @Andrefei

It's actually a good idea to have a configuration option for this. I'm going to plan the change