sqlserve数据库学习笔记

最新推荐文章于 2024-07-14 19:46:27 发布

莫泊桑891

最新推荐文章于 2024-07-14 19:46:27 发布

阅读量128

点赞数

文章标签：数据库

本文链接：https://blog.csdn.net/qq_63514393/article/details/125745234

版权

怎样用T-SQL语句创建数据库：

create database badmintonCount
on primary
(
	NAME= 'badmintonCountDB',
	FILENAME='D:\badmintonCountDB.mdf',
	SIZE=8mb,
	FILEGROWTH=100mb,
	MAXSIZE=2000mb
)
LOG
ON
(
	NAME= 'badmintonCountLog',
	FILENAME='D:\badmintonCountlog.ldf',
	SIZE=8mb,
	FILEGROWTH=100mb,
	MAXSIZE=2000mb
)

将一列改为非空约束并进行主键约束

alter table BadInfo
alter column ID INT not null;

go

alter table BadInfo
add constraint BadInfo_ID primary key clustered(ID)
 
-- constraint后面跟的是键的名称

创建外来约束

create table ConditionLevel(
Id int primary key,
Condition varchar(20)
)

use badmintonCount
alter table BadInfo
add Account varchar(20),Password varchar(50), PrizePerHour decimal(10,2),conditionLevelID int foreign key references ConditionLevel(Id);