//SQL中新建的数据库文件默认存放路径为:C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data
//创建数据库
use master
go
if exists (select * from sysdatabases where name='aaaaa' )
drop database aaaaa
create database aaaaa
on primary(name='aaaaa', fileName="f:\blog\aaaaa.mdf")
go
//创建表
if exists(select * from sysobjects where name='bbbbb')
drop table bbbbb
create table bbbbb(
id int primary key identity(1,1),
name varchar(5)
)
//为aa表某字段添加外键
alter table aa add constraint FK_bb foreign key (aid) references bb (bid)
SQL建表命令
最新推荐文章于 2024-07-18 09:45:00 发布