Book a Demo

Author Topic: Generate Table Owner  (Read 3446 times)

MichaelHanson

  • EA User
  • **
  • Posts: 31
  • Karma: +0/-0
  • EA is the best
    • View Profile
Generate Table Owner
« on: April 27, 2004, 12:20:33 pm »
Been trying to get this feature to work since it appeared in the Generate DDL dialog.

Can anyone tell me how to get this to work because naming tables to include the owner name is irritating because it makes more work and generates code that has to be modified
Mike Hanson
Microsoft Technology Specialist

hd

  • EA Administrator
  • EA User
  • *****
  • Posts: 312
  • Karma: +0/-0
    • View Profile
Re: Generate Table Owner
« Reply #1 on: April 27, 2004, 06:27:50 pm »
Go to the Tags tab in the Table Properties dialog. Enter "owner" in the Tag: field, and "ownername" in the Value: field (without the double quotes).

MichaelHanson

  • EA User
  • **
  • Posts: 31
  • Karma: +0/-0
  • EA is the best
    • View Profile
Re: Generate Table Owner
« Reply #2 on: April 28, 2004, 12:12:48 am »
Great, thanks for that.

Can you enlighten me as to the use of the Table Space textbox on the Details tab of a Table property sheet

Mike
Mike Hanson
Microsoft Technology Specialist

MichaelHanson

  • EA User
  • **
  • Posts: 31
  • Karma: +0/-0
  • EA is the best
    • View Profile
Re: Generate Table Owner
« Reply #3 on: April 28, 2004, 03:03:56 am »
Interesting results with this feature.

Have added the tag "owner" to each table with a value of "dbo".

Now if I use a Generate DDL command directly on an individual table in my model the owner is generated correctly.

But if I select the package containing my data model in the Project Explorer and choose Generate DDL from the toobar, set the Generate Table Owner option on and Generate the Tag is ignored and no owner is generated.  This happens whether I choose to generate a single file or one for each table.

Strange, I will report this as a bug using the relevant feature from the Sparx site
Mike Hanson
Microsoft Technology Specialist