How can we help you today? How can we help you today?

How is a schema created and used?

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 from a pre-defined set of schemas when creating a table.  What is more is that when setting up or createing a database through Azure, we are given the opportuniityh to use a sample database and this is where "SalesLT" comes from and so there must be some place where we can define a schema with Azure Data Studio.  Where would that be?  It was generated when deciding to use a demo sample database.  So there must be some way, using SQL code or otherwise, to generate a schema.

Xarzu
0

Comments

5 comments

Sort by
  • JoshH
    Hello, 

    This appears to be a more generic database behavior question than one related to Redgate products. I would suggest posting it somewhere like StackOverflow. You might find a more relevant answer there.
    JoshH
    1
  • kanelime
    It seems like this isn't about Redgate products at all, but rather general database behavior. I propose you submit it to a site like StackOverflow. That could lead you to a better answer. 
    io games 
    kanelime
    -1
  • Finley Pearce

    That’s a great question! I remember being confused the first time I worked with schemas in Azure Data Studio too. I realized that a schema is more like a namespace to organize tables, not just their relationships. Creating custom schemas can be done through SQL code as well. Basketball Stars

    Finley Pearce
    -1
  • laurarobinette

    That sounds amazing

    laurarobinette
    -1
  • daniyaltaqi

    This is a really helpful explanation. The distinction between a database schema as a logical namespace (such as SalesLT) and the broader idea of a database design/schema can definitely be confusing at first. The CREATE SCHEMA approach makes it much clearer how custom schemas are created and then used when creating tables. Thanks for explaining where SalesLT comes from and how Azure Data Studio handles it!

    I also found this useful resource: www.nba2k20obb.com

    daniyaltaqi
    -1

Add comment

Please sign in to leave a comment.