Menu

#405 [MS SQL] Edit table when schema is not dbo

4.0.3
closed-fixed
nobody
5
2025-02-22
2014-05-06
No

Editing table in mssql when schema is not dbo fail whit the error 'the object not exist'.

Discussion

  • Jakub Vrána

    Jakub Vrána - 2018-01-30
    • summary: edit mssql table when schema is not dbo --> [MS SQL] Edit table when schema is not dbo
     
  • AJas

    AJas - 2020-01-11

    I didn't work on dbo schema at all, so I think thats exactly the error reported by me in there:
    [MSsql] Wrong SQL code generated when editing tables that are inside schema
    When I alter table inside custom schema, generated code doesn't contain schema name and server can't find the table. In result we get error: The object not exist.
    I have to click Show Code and than Edit, and manually add schema name on front of table name. Than I can execute without problems.

     
  • Jakub Vrána

    Jakub Vrána - 2025-02-22
    • status: open --> closed-fixed
     
  • Jakub Vrána

    Jakub Vrána - 2025-02-22

    Fixed by 5d18df1d.

     

Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.