How to create a schema?
-
Ok, this may sound a little elementary but I have no clue what a "schema" is. I know quite a bit about Sql Server but it's not my area of expertise. My boss just emailed me saying he needs me to create a schema of one of our databases. What exactly is a schema and how do I go about creating one in enterprise manager? Thanks in advance. -Goalie35
-
Ok, this may sound a little elementary but I have no clue what a "schema" is. I know quite a bit about Sql Server but it's not my area of expertise. My boss just emailed me saying he needs me to create a schema of one of our databases. What exactly is a schema and how do I go about creating one in enterprise manager? Thanks in advance. -Goalie35
SQL Server Books Online says a schema "can be thought of as a conceptual object containing definitions of tables, views, and permissions." But your boss probably just wants you to make a database diagram that has all the tables, relationships, keys, etc. in your database. The Diagrams node is right above the Tables node in the Enterprise manager. There isn't much to it. ---------- There go my people. I must find out where they are going so I can lead them. - Alexander Ledru-Rollin
-
Ok, this may sound a little elementary but I have no clue what a "schema" is. I know quite a bit about Sql Server but it's not my area of expertise. My boss just emailed me saying he needs me to create a schema of one of our databases. What exactly is a schema and how do I go about creating one in enterprise manager? Thanks in advance. -Goalie35
schema is a logical representation of Business logic from a database. example: You have a large ERP system and have 4 schemas One each for Accounts, Stock Control, Purchasing and Sales. Consider it a logical database within a physical database. Look where you want to go not where you don't want to crash. Bikers Bible