SQL: To Schema or not to schema?

To schema or not to schema – That is the question;Whether it is easier to find a table with a Schema.TableName ;Or to simply build one with a strong naming convention,and, by opposing schemas, force other developers to learn (and re-learn) No more, with schemas ; It’s an interesting dilemma – especially when designing a database for an organization who changes standards with almost every new development project. One recent project implemented schemas along with a naming convention so much that the schema name was repeated in the name of the table: SCHEMA.SCH_ClientName Definitely overkill. But then if I want …



48 Stonemeadow Drive
Kanata, Ontario K2M2K2

+1 613-851-4496 Contact Us



Coming Soon