/*==============================================================*/
/* Table: CS_Return */
/*==============================================================*/
create table dbo.CS_Return (
ReturnId int identity(1,1),
SalesId bigint null,
ReturnMan varchar(50) null,
ReturnContent varchar(5000) null,
ReturnDate datetime null,
constraint PK_CS_Return primary key ()
WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
)
ON [PRIMARY]
END
go/*==============================================================*/
/* Table: CS_Sales */
/*==============================================================*/
create table dbo.CS_Sales (
SalesId int identity(1,1),
SalesCode varchar(50) null,
comodBarcode varchar(50) null,
comodid varchar(50) null,
Brand varchar(50) null,
comodName varchar(50) null,
modul varchar(50) null,
Unit varchar(50) null,
Supplier varchar(50) null,
Prices money null,
number int null,
TotalMoney money null,
practical money null constraint DF_CS_Sales_practical default 0,
TotalPractical money null constraint DF_CS_Sales_TotalPractical default 0,
Discount varchar(50) null,
C_date datetime null,
content varchar(200) null,
AuditState varchar(50) null,
AuditUserName varchar(50) null,
AuditDate varchar(50) null,
ditUserName varchar(50) null,
EditDate datetime null,
WarrTime int null,
GuestId varchar(50) null,
userId int null,
WarehouseId varchar(50) null,
SalesContent varchar(200) null,
Warehouse varchar(50) null,
typeSale int null constraint DF_CS_Sales_typeSale default 0,
DeliveryDate datetime null,
Saleman int null,
Gifts varchar(200) null,
ProcMoney money null,
IsOut int null constraint DF_CS_Sales_IsOut default 0,
IsDel int null constraint DF_CS_Sales_Isjs default 0,
deptid int null,
typeStock varchar(50) null,
Isreturn int null,
OutWarehouse varchar(50) null,
constraint PK_CS_Sales primary key ()
WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
)
ON [PRIMARY]
END
go;
总是出这个错
ORA-00922: 缺少或无效选项
/* Table: CS_Return */
/*==============================================================*/
create table dbo.CS_Return (
ReturnId int identity(1,1),
SalesId bigint null,
ReturnMan varchar(50) null,
ReturnContent varchar(5000) null,
ReturnDate datetime null,
constraint PK_CS_Return primary key ()
WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
)
ON [PRIMARY]
END
go/*==============================================================*/
/* Table: CS_Sales */
/*==============================================================*/
create table dbo.CS_Sales (
SalesId int identity(1,1),
SalesCode varchar(50) null,
comodBarcode varchar(50) null,
comodid varchar(50) null,
Brand varchar(50) null,
comodName varchar(50) null,
modul varchar(50) null,
Unit varchar(50) null,
Supplier varchar(50) null,
Prices money null,
number int null,
TotalMoney money null,
practical money null constraint DF_CS_Sales_practical default 0,
TotalPractical money null constraint DF_CS_Sales_TotalPractical default 0,
Discount varchar(50) null,
C_date datetime null,
content varchar(200) null,
AuditState varchar(50) null,
AuditUserName varchar(50) null,
AuditDate varchar(50) null,
ditUserName varchar(50) null,
EditDate datetime null,
WarrTime int null,
GuestId varchar(50) null,
userId int null,
WarehouseId varchar(50) null,
SalesContent varchar(200) null,
Warehouse varchar(50) null,
typeSale int null constraint DF_CS_Sales_typeSale default 0,
DeliveryDate datetime null,
Saleman int null,
Gifts varchar(200) null,
ProcMoney money null,
IsOut int null constraint DF_CS_Sales_IsOut default 0,
IsDel int null constraint DF_CS_Sales_Isjs default 0,
deptid int null,
typeStock varchar(50) null,
Isreturn int null,
OutWarehouse varchar(50) null,
constraint PK_CS_Sales primary key ()
WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
)
ON [PRIMARY]
END
go;
总是出这个错
ORA-00922: 缺少或无效选项
2。constraint PK_CS_Sales primary key () ,PK字段在那里?括号内要有字段
3。WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
)
ON [PRIMARY]
这段是什么东西?oracle貌似没这种东东。。