if exists (select * from sysobjects where name='bin'and type='u' )
drop table bin ----判断表
----------------------------------------------
create table bin ------添加表
(
bin_id varchar(10),
bin_name varchar(20),
bin_age int
)
create table bing ------添加表
(
bing_id varchar(10),
bing_name varchar(20),
bing_age int
)
----------------------------------------------
drop table bin -----删除表
----------------------------------------------
alter table bin
add bin_sex char(2) ---添加列
alter table bin
add bin_date datetime
-------
alter table bin
alter column bin_sex int --修改列
------
alter table bin
drop column bin_sex ---删除列
---------------------------------------------------------------
insert into bin
values ('HB001','彬彬',18,'女') ---增加一行
insert into bin(bin_id,bin_name)
values ('HB002','尼尼')
insert into bin
values ('HB003','啊啊',20,'女','89-01-12')
-------------------
delete from bin where bin_id='HB001' and bin_name='彬彬' --删除一行
truncate table bin --------删除所有行
-------------------
update bin set bin_age=20 where bin_name='尼尼' ---修改一行
-------------------
----增加主键列(该列的值不为空(no null))---
alter table bin
add constraint fk_sno
primary key clustered(bin_id)
----
insert into bin(bin_name)
values ('尼尼')
----
-----------------------
insert into bing ----(查询一个表中的信息添加到另一个表中)
select * from bin where bin_age=19
-------------------
select * from bin ---查询表中的所有信息
select * from bing