Defining a database table

[skiwi]

I'd life to define a database table so that the resulting DDL generated would look similar to

Code: [Select]

CREATE TABLE Archive.dbo.Records
(
        [Id] [uniqueidentifier] ROWGUIDCOL NOT NULL UNIQUE,
        [SerialNumber] INTEGER UNIQUE,
        [Chart] VARBINARY(MAX) FILESTREAM NULL
)Its not clear to me where to enter the qualifiers such as ROWGUIDCOL, UNIQUE, and FILESTREAM.

Can anyone help please?

[skiwi]

Also how to provide the attributes to correctly correct the database, if that is possible in EA?

Code: [Select]

CREATE DATABASE NorthPole
ON
PRIMARY (
      NAME = NorthPoleDB,
      FILENAME = 'C:\Temp\NP\NorthPoleDB.mdf'
), FILEGROUP NorthPoleFS CONTAINS FILESTREAM(
      NAME = NorthPoleFS,
    FILENAME = 'C:\Temp\NP\NorthPoleFS')
LOG ON (                       
      NAME = NorthPoleLOG,
    FILENAME = 'C:\Temp\NP\NorthPoleLOG.ldf')


[Helmut Ortmann]

Hi,

you can change the Template for the DDL generation.

See: http://sparxsystems.com/enterprise_architect_user_guide/12.1/database_engineering/edit_ddl_templates.html

Helmut