34,587
社区成员
发帖
与我相关
我的任务
分享
CREATE DATABASE Mybase
ON
KA(
NAME = mybaseLog,
FILENAME = 'D:\mybase.mdf',
SIZE = 500MB,
MAXSIZE = 5000MB,
FILEGROWTH = 20MB )
CREATE TABLE [KA].[USERINFO]( --这里的ka指的是架构 形如 dbo, db_owner....
[user_id] [nchar](20) NOT NULL,
[user_name] [nchar](10) NULL,
[user_password] [nchar](10) NULL,
[user_auth] [nchar](4) NULL,
CONSTRAINT [PK_USERINFO] PRIMARY KEY CLUSTERED
(
[user_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [KA]
) ON [KA] ---这里的ka指的是文件组