Skip to content

SqlServer RevEng: Scaffold default schema #9318

@smitpatel

Description

@smitpatel

At present we identify the default schema using SELECT SCHEMA_NAME()
But default schema is user specific. So different users may have different schema. This can give rise to different scaffolded code based on who ran the rev eng & cause ugly version control diffs especially once update model for database is implemented.

If we stop scaffolding default schema then if the schema is anything other than "dbo" (which is our default) then it will be used in scaffolding objects. (like ToTable("tablename", "nondefaultschema")) but it will produce more consistent code across users.

Another option is to take command line argument for default schema so user can specify what to consider as default schema as opposed to we trying to guess based on user. But we can defer this to customer feedback.

@bricelam - comments?

Metadata

Metadata

Assignees

No one assigned

    Projects

    No projects

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions