go
create database studb
on primary
(
name=studb_pri,
filename='E:\学习笔记\sqlserver\主文件和日志文件存放\studb.mdf',
size=10mb,
maxsize=20mb,
filegrowth=5mb
)
use studb
go
create table table_stuinfo(
sno int primary key,
sn varchar(10) not null
)
go
go
sp_tables stu
go
sp_spaceused stu
go
sp_help stu
alter table table_stuinfo
add
address varchar(80)
alter table table_stuinfo
alter
column address varchar(50) not null
alter table table_stuinfo
drop
column address
alter table table_stuinfo
drop
column address,sn
drop table table_stuinfo