GUID default value

Greetings

We are developing a complex system, which will run on Oracle, MS SQL
Server and MS Access databases. All the databases are to be replicated.
We are using a single common database scheme. For each table we have a
GUID column, which is filled once a new record is inserted. We have
default values for the GUID column in Oracle DB and MS SQL.

Could you please tell me which is the correct column data type for GUID
in MS Access and how can we set a default value for the column?

Here is a sample for MS SQL Server

create table PRODUCT_SRC (
ID int identity,
CR_OPE_ID int null default
dbo.GET_CURRENT_USER_ID(),
OPE_ID int null default
dbo.GET_CURRENT_USER_ID(),
CH_DATE datetime not null default
GETDATE(),
CR_DATE datetime not null default
GETDATE(),
STATUS char(1) not null default 'A',
GUID uniqueidentifier not null default newid(),
NAME varchar(100) not null,
constraint PK_PRODUCT_SRC primary key (ID)
)
go

and Oracle

create table PRODUCT_SRC (
ID INTEGER not null,
CR_OPE_ID INTEGER,
OPE_ID INTEGER,
CH_DATE DATE default SYSDATE
not null,
CR_DATE DATE default SYSDATE
not null ,
STATUS CHAR(1) default 'A' not
null,
GUID RAW(32) default
sys_guid(),
NAME VARCHAR2(100) not null,
constraint PK_PRODUCT_SRC primary key (ID)
);


Thanks, Vladimir.

.

Relevant Pages

  • Re: Oracle vs MSSQL Parameters
    ... My SQL is ... ported between those databases. ... The instance of the DbCommand ... Oracle directly); the MS Data Set Generator tool used in the VS.NET IDE also ...
    (microsoft.public.dotnet.framework.adonet)
  • GUID default value
    ... We are developing a complex system, which will run on Oracle, MS SQL ... All the databases are to be replicated. ... GUID column, which is filled once a new record is inserted. ...
    (microsoft.public.access.replication)
  • Re: Need design advice. Whats my best approach for storing this data?
    ... With something like DB2 or Oracle here, ... relational databases work, but I think it's with the trouble. ... a declarative language, and in principle, your SQL code ...
    (comp.lang.python)
  • Re: MS SQL server Meata data question
    ... >browsing tools poked around and found that the databases in the system were ... >info about the architecture of sql server's inner workings to use it. ... >I need to do this for Oracle too but I think the native support for Oracle ... PHP DB Edit Toolkit -- PHP scripts for building ...
    (comp.lang.php)
  • RE: GUID default value
    ... but I am assuming that you are importing a GUID ... > We are developing a complex system, which will run on Oracle, MS SQL ... All the databases are to be replicated. ... > GUID column, which is filled once a new record is inserted. ...
    (microsoft.public.access.tablesdbdesign)
Loading