Add primary Key as GUID automatic generation

[MrKBA]

I have Some table in database (Access, SQLServer and Oracle) haven' t Primary Key.Client need to do a replication for this database. I ask how do the update script for one table to add primary key as GUID automatic (it means when I add a record as before there is no need to edit source code) I did this for SQLServer and it works but for Access and Oracle no idea how to do this :( example :

create table [SAC_MEMBERSHIPS](
id_group nvarchar(40) FOREIGN KEY REFERENCES SAC_SUBJECTS(id_subject),
id_user nvarchar(40) FOREIGN KEY REFERENCES SAC_SUBJECTS(id_subject),
id_memberships UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID() PRIMARY KEY
)/

ALTER TABLE [SAC_MEMBERSHIPS]
ADD [id_memberships] UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID() PRIMARY KEY
ON [PRIMARY]
/

[Kornfeld Eliyahu Peter]

create table [table] (
id raw(32) default sys_guid(),
...,
constraint pk_id primary key (id)
);

I'm not questioning your powers of observation; I'm merely remarking upon the paradox of asking a masked man who he is. (V)

[MrKBA]

Thank you for that. But what about Access database ?

[Kornfeld Eliyahu Peter]

I don't know him!

I'm not questioning your powers of observation; I'm merely remarking upon the paradox of asking a masked man who he is. (V)

[MrKBA]

I talk about Microsoft Office access

[Kornfeld Eliyahu Peter]

Please do not use rude words here...

I'm not questioning your powers of observation; I'm merely remarking upon the paradox of asking a masked man who he is. (V)

[MrKBA]

sorry if I did a mistake

[Kornfeld Eliyahu Peter]

The only mistake you did that you didn't realized the joke icon :laugh:

I'm not questioning your powers of observation; I'm merely remarking upon the paradox of asking a masked man who he is. (V)

[Estys]

For ms access the best approximation is

id_memberships AUTOINCREMENT PRIMARY KEY

Cheers

[jschell]

What are you going to do if the record is updated rather than added?

[Bernhard Hiller]

Also Access has a Guid datatype.

CREATE TABLE [SAC_MEMBERSHIPS]
(
[id_memberships] GUID NOT NULL PRIMARY KEY,
...

[MrKBA]

Thank you , But I need it to be in automatic GUID forme.

[MrKBA]

I use

id_memberships GUID PRIMARY KEY DEFAULT GenGUID() NOT NULL

But I can do in Update Request SQL :( Have you an idea how do the Update ?