USE [db_NLMRPII] GO /****** 对象: Table [dbo].[t_Permission] 脚本日期: 06/21/2011 10:44:07 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[t_Permission]( [f_intPermissionId] [int] IDENTITY(1,1) NOT NULL, [f_intOrganizationId] [int] NOT NULL, [f_strPermissionNumber] [varchar](50) NULL, [f_strPermissionName] [varchar](50) NULL, [f_dtmCreated] [datetime] NOT NULL CONSTRAINT [DF_t_Right_f_dtmCreated] DEFAULT (getdate()), [f_dtmLastModified] [datetime] NOT NULL CONSTRAINT [DF_t_Right_f_dtmLastModified] DEFAULT (getdate()), [f_strNote] [varchar](50) NULL, CONSTRAINT [PK_t_Right] PRIMARY KEY CLUSTERED ( [f_intPermissionId] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_PADDING OFF 在 SQL Server 企业管理器中,右键单击表,选择 "编写表脚本为" > "Create 到" 。