Permission 表建表语句（编号：20110621A1030 ）

最新推荐文章于 2023-01-06 18:34:00 发布

杠杠峰

最新推荐文章于 2023-01-06 18:34:00 发布

阅读量596

点赞数

本文链接：https://blog.csdn.net/lmn13/article/details/6557934

版权

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 到" 。