Question

如何用T-SQL语言在数据库中创建表

如何在已知数据库中创建表比如我已经在查询分析器中用SQL语言创建了一个数据库，那么如何在这个数据库中创建一个表呢？
create database scd2
on primary
(
name = 'scd2',
filename = 'f:\scd2\scd2_data.mdf',
size = 10mb,
filegrowth = 10%
)
log on
(
name = 'scd2_log',
filename = 'f:\scd2\scd2_log.ldf',
size = 1mb,
maxsize = 5mb,
filegrowth = 10%
)

Answer 1

比如要创建个 USER 表
USE scd2
CREATE TABLE USER
(ID CHAR(8) NOT NULL PRIMARY KEY,
NAME NVARCHAR(20) NOT NULL,
PWD NVARCHAR(20) NOT NULL,
)
GO