T-SQL创建表结构-主键自增长

最新推荐文章于 2024-04-11 14:44:04 发布

漫彧明柒

最新推荐文章于 2024-04-11 14:44:04 发布

阅读量2k

点赞数 1

分类专栏： SQL Server 文章标签：创建表

本文链接：https://blog.csdn.net/qq_31971935/article/details/50750240

版权

SQL Server 专栏收录该内容

23 篇文章 0 订阅

订阅专栏

                                        CREATE TABLE SYS_User2(
                                            [RowGuid] [nvarchar](50) NOT NULL,
                                            [RowID] [int] IDENTITY(1,1) NOT NULL,
                                            [OperationDate] [datetime] NOT NULL,
                                            [OperationUserGuid] [int] NOT NULL,
                                            [UserName] [nvarchar](50) NOT NULL,
                                            [DisplayName] [nvarchar](50) NOT NULL,
                                            [sex] [nvarchar](50) NULL,
                                            [ZJLX] [int] NULL,
                                            [ZJHM] [nvarchar](50) NULL,
                                            [CSRQ] [datetime] NULL,
                                            [PassWord] [nvarchar](50) NOT NULL,
                                            [JX] [int] NULL,
                                            [AttachGuid] [int] NULL,
                                            [ZW] [int] NULL,
                                            [ZT] [bit] NULL,
                                            [LXFS] [nvarchar](50) NULL,
                                         Primary Key([RowID])