|
|
发表于 2018-6-22 05:27:46
|
显示全部楼层
|
备份账套,用这个语句建立试试:USE [UFSystem]\nGO\n\n/****** Object: Table [dbo].[UA_Task] Script Date: 04/07/2017 17:01:15 ******/\nSET ANSI_NULLS ON\nGO\n\nSET QUOTED_IDENTIFIER ON\nGO\n\nSET ANSI_PADDING ON\nGO\n\nCREATE TABLE [dbo].[UA_Task](\n\t[cAcc_Id] [varchar](3) NOT NULL,\n\t[iYear] [smallint] NOT NULL,\n\t[cUser_Id] [varchar](12) NOT NULL,\n\t[cAuth_Id] [varchar](12) NOT NULL,\n\t[cStation] [varchar](20) NOT NULL,\n\t[cTaskId] [varchar](20) NOT NULL,\n\t[iLogId] [float] NULL,\n\t[cSub_id] [varchar](2) NULL,\n\t[cAppServer] [varchar](80) NULL\n) ON [PRIMARY]\n\nGO\n\nSET ANSI_PADDING OFF\nGO\n\nALTER TABLE [dbo].[UA_Task] WITH CHECK ADD FOREIGN KEY([cTaskId])\nREFERENCES [dbo].[UA_TaskLog] ([cTaskId])\nGO\n\nALTER TABLE [dbo].[UA_Task] WITH CHECK ADD FOREIGN KEY([cUser_Id])\nREFERENCES [dbo].[UA_User] ([cUser_Id])\nGO |
|