Forum Discussion
How do I use Azure Data Studio with schemas?
I had thought that a database schema was the name of the structure on which tables are interconnected by primary keys and foreign keys. But in the tool, Azure Data Studio, the user is asked to select...
Within Azure Data Studio, schemas are not inherently defined by the tool itself; rather, they are SQL Server database constructs that organize tables and other objects under a logical namespace. The SalesLT schema you encounter originates from the AdventureWorksLT sample database provided by Azure. Administrators can create or manage schemas directly through Transact‑SQL (T‑SQL) commands, ensuring proper logical separation and governance of database objects.
https://learn.microsoft.com/en-us/sql/relational-databases/security/authentication-access/create-a-database-schema?view=sql-server-ver17