Book a Demo

Author Topic: Data Model Question. Help  (Read 3877 times)

saiine

  • EA Novice
  • *
  • Posts: 18
  • Karma: +0/-0
    • View Profile
Data Model Question. Help
« on: March 16, 2012, 08:40:44 am »
Hi forums,

I've asked this before with no reply, hoping someone can help.

I rely on EA for data modeling and DDL generation. Is there an option to include the prefix [dbo] in front of CREATE TABLES. E.G, CREATE TABLE [dbo].foo

The problem I am having deals with the security policy at my work. If I do not include dbo it will create the tables with my username.

I have been manually searching and replacing each DDL script  :'(

I do see a "Include DBO" option, but that seems to do nothing?

Thanks!

saiine

  • EA Novice
  • *
  • Posts: 18
  • Karma: +0/-0
    • View Profile
Re: Data Model Question. Help
« Reply #1 on: March 16, 2012, 09:22:24 am »
Replying to my own post here, as I believe I finally figured this out.

If you right click on a table element and go to properties, then click the 'Tagged Values' tab, there is a option for Owner.

Seems a bit of a odd place to put this, but so be it.

hd

  • EA Administrator
  • EA User
  • *****
  • Posts: 312
  • Karma: +0/-0
    • View Profile
Re: Data Model Question. Help
« Reply #2 on: March 16, 2012, 11:42:23 am »
Package context menu | Code Engineering | Reset DBMS Options...

Luis J. Lobo

  • EA User
  • **
  • Posts: 252
  • Karma: +0/-0
  • IT Consultant
    • View Profile
Re: Data Model Question. Help
« Reply #3 on: March 23, 2012, 10:50:54 am »
Quote
Package context menu | Code Engineering | Reset DBMS Options...

Yeah!