![](https://csdnimg.cn/release/download_crawler_static/87247428/bga.jpg)
name='wl_system_data',
filename=
'C:\SQLhomework\wl_system_data.mdf',
size=10mb,maxsize=50mb,filegrowth=2mb
)
LOG ON
(
name='wl_system_log',
filename='C:\SQLhomework\wl_system_log.ldf',
size=10mb,
maxsize=50mb,
filegrowth=2mb
)
2、建立基本表构造
USE WL_System
Go
Create table 制造商
(
制造商编号char(10) primary key,
名称char(10)NOT NULL,
联系人char(10)NOT NULL,
地址varchar(30),
电话号码char(20)NOT NULL,
网站char(20)