?? sms.sql
字號:
--------------------------------------------------------------
----超市管理系統
--------------------------------------------------------------
--------------------------------------------------------------
----建庫
--------------------------------------------------------------
use master
go
if exists (select 1 from sysdatabases where name = 'DB_SMS')
drop database DB_SMS
go
create database DB_SMS
on primary
(
/*主數據文件描述*/
name = 'DB_SMS_data',
filename = 'D:\DataBase\DB_SMS_data.mdf',
size = 5MB,
maxsize = 100MB,
)
log on
(
/*日志文件描述*/
name = 'DB_SMS_log',
filename = 'D:\DataBase\DB_SMS_log.ldf',
size = 3MB,
filegrowth = 1MB
)
go
--------------------------------------------------------------
----建表
--------------------------------------------------------------
use DB_SMS
go
if exists (select 1
from sys.sysreferences r join sys.sysobjects o on (o.id = r.constid and o.type = 'F')
where r.fkeyid = object_id('TB_EMPLOYEE') and o.name = 'FK_TB_EMPLO_RELATIONS_TB_EMPLO')
alter table TB_EMPLOYEE
drop constraint FK_TB_EMPLO_RELATIONS_TB_EMPLO
go
if exists (select 1
from sys.sysreferences r join sys.sysobjects o on (o.id = r.constid and o.type = 'F')
where r.fkeyid = object_id('TB_GOODS') and o.name = 'FK_TB_GOODS_RELATIONS_TB_GOODS')
alter table TB_GOODS
drop constraint FK_TB_GOODS_RELATIONS_TB_GOODS
go
if exists (select 1
from sys.sysreferences r join sys.sysobjects o on (o.id = r.constid and o.type = 'F')
where r.fkeyid = object_id('TB_SALE_GOODS') and o.name = 'FK_TB_SALE__RELATIONS_TB_GOODS')
alter table TB_SALE_GOODS
drop constraint FK_TB_SALE__RELATIONS_TB_GOODS
go
if exists (select 1
from sys.sysreferences r join sys.sysobjects o on (o.id = r.constid and o.type = 'F')
where r.fkeyid = object_id('TB_SALE_GOODS') and o.name = 'FK_TB_SALE__RELATIONS_TB_SALE_')
alter table TB_SALE_GOODS
drop constraint FK_TB_SALE__RELATIONS_TB_SALE_
go
if exists (select 1
from sys.sysreferences r join sys.sysobjects o on (o.id = r.constid and o.type = 'F')
where r.fkeyid = object_id('TB_SALE_SHEET') and o.name = 'FK_TB_SALE__RELATIONS_TB_EMPLO')
alter table TB_SALE_SHEET
drop constraint FK_TB_SALE__RELATIONS_TB_EMPLO
go
if exists (select 1
from sys.sysreferences r join sys.sysobjects o on (o.id = r.constid and o.type = 'F')
where r.fkeyid = object_id('TB_STOCK_GOODS') and o.name = 'FK_TB_STOCK_RELATIONS_TB_STOCK')
alter table TB_STOCK_GOODS
drop constraint FK_TB_STOCK_RELATIONS_TB_STOCK
go
if exists (select 1
from sys.sysreferences r join sys.sysobjects o on (o.id = r.constid and o.type = 'F')
where r.fkeyid = object_id('TB_STOCK_GOODS') and o.name = 'FK_TB_STOCK_RELATIONS_TB_GOODS')
alter table TB_STOCK_GOODS
drop constraint FK_TB_STOCK_RELATIONS_TB_GOODS
go
if exists (select 1
from sys.sysreferences r join sys.sysobjects o on (o.id = r.constid and o.type = 'F')
where r.fkeyid = object_id('TB_STOCK_SHEET') and o.name = 'FK_TB_STOCK_RELATIONS_TB_PROVI')
alter table TB_STOCK_SHEET
drop constraint FK_TB_STOCK_RELATIONS_TB_PROVI
go
if exists (select 1
from sys.sysreferences r join sys.sysobjects o on (o.id = r.constid and o.type = 'F')
where r.fkeyid = object_id('TB_STOCK_SHEET') and o.name = 'FK_TB_STOCK_RELATIONS_TB_EMPLO')
alter table TB_STOCK_SHEET
drop constraint FK_TB_STOCK_RELATIONS_TB_EMPLO
go
if exists (select 1
from sys.sysreferences r join sys.sysobjects o on (o.id = r.constid and o.type = 'F')
where r.fkeyid = object_id('TB_STORAGE') and o.name = 'FK_TB_STORA_RELATIONS_TB_GOODS')
alter table TB_STORAGE
drop constraint FK_TB_STORA_RELATIONS_TB_GOODS
go
if exists (select 1
from sys.sysreferences r join sys.sysobjects o on (o.id = r.constid and o.type = 'F')
where r.fkeyid = object_id('TB_SUPPLY') and o.name = 'FK_TB_SUPPL_RELATIONS_TB_PROVI')
alter table TB_SUPPLY
drop constraint FK_TB_SUPPL_RELATIONS_TB_PROVI
go
if exists (select 1
from sys.sysreferences r join sys.sysobjects o on (o.id = r.constid and o.type = 'F')
where r.fkeyid = object_id('TB_SUPPLY') and o.name = 'FK_TB_SUPPL_RELATIONS_TB_GOODS')
alter table TB_SUPPLY
drop constraint FK_TB_SUPPL_RELATIONS_TB_GOODS
go
if exists (select 1
from sysindexes
where id = object_id('TB_EMPLOYEE')
and name = 'Relationship_8_FK'
and indid > 0
and indid < 255)
drop index TB_EMPLOYEE.Relationship_8_FK
go
if exists (select 1
from sysobjects
where id = object_id('TB_EMPLOYEE')
and type = 'U')
drop table TB_EMPLOYEE
go
if exists (select 1
from sysobjects
where id = object_id('TB_EMPLOYEE_TYPE')
and type = 'U')
drop table TB_EMPLOYEE_TYPE
go
if exists (select 1
from sysindexes
where id = object_id('TB_GOODS')
and name = 'Relationship_1_FK'
and indid > 0
and indid < 255)
drop index TB_GOODS.Relationship_1_FK
go
if exists (select 1
from sysobjects
where id = object_id('TB_GOODS')
and type = 'U')
drop table TB_GOODS
go
if exists (select 1
from sysobjects
where id = object_id('TB_GOODS_TYPE')
and type = 'U')
drop table TB_GOODS_TYPE
go
if exists (select 1
from sysobjects
where id = object_id('TB_MEMBER')
and type = 'U')
drop table TB_MEMBER
go
if exists (select 1
from sysobjects
where id = object_id('TB_PROVIDER')
and type = 'U')
drop table TB_PROVIDER
go
if exists (select 1
from sysindexes
where id = object_id('TB_SALE_GOODS')
and name = 'Relationship_9_FK'
and indid > 0
and indid < 255)
drop index TB_SALE_GOODS.Relationship_9_FK
go
if exists (select 1
from sysindexes
where id = object_id('TB_SALE_GOODS')
and name = 'Relationship_3_FK'
and indid > 0
and indid < 255)
drop index TB_SALE_GOODS.Relationship_3_FK
go
if exists (select 1
from sysobjects
where id = object_id('TB_SALE_GOODS')
and type = 'U')
drop table TB_SALE_GOODS
go
if exists (select 1
from sysindexes
where id = object_id('TB_SALE_SHEET')
and name = 'Relationship_7_FK'
and indid > 0
and indid < 255)
drop index TB_SALE_SHEET.Relationship_7_FK
go
if exists (select 1
from sysobjects
where id = object_id('TB_SALE_SHEET')
and type = 'U')
drop table TB_SALE_SHEET
go
if exists (select 1
from sysindexes
where id = object_id('TB_STOCK_GOODS')
and name = 'Relationship_10_FK'
and indid > 0
and indid < 255)
drop index TB_STOCK_GOODS.Relationship_10_FK
go
if exists (select 1
from sysindexes
where id = object_id('TB_STOCK_GOODS')
and name = 'Relationship_4_FK'
and indid > 0
and indid < 255)
drop index TB_STOCK_GOODS.Relationship_4_FK
go
if exists (select 1
from sysobjects
where id = object_id('TB_STOCK_GOODS')
and type = 'U')
drop table TB_STOCK_GOODS
go
if exists (select 1
from sysindexes
where id = object_id('TB_STOCK_SHEET')
and name = 'Relationship_6_FK'
and indid > 0
and indid < 255)
drop index TB_STOCK_SHEET.Relationship_6_FK
go
if exists (select 1
from sysindexes
where id = object_id('TB_STOCK_SHEET')
and name = 'Relationship_5_FK'
and indid > 0
and indid < 255)
drop index TB_STOCK_SHEET.Relationship_5_FK
go
if exists (select 1
from sysobjects
where id = object_id('TB_STOCK_SHEET')
and type = 'U')
drop table TB_STOCK_SHEET
go
if exists (select 1
from sysindexes
where id = object_id('TB_STORAGE')
and name = 'Relationship_2_FK'
and indid > 0
and indid < 255)
drop index TB_STORAGE.Relationship_2_FK
go
if exists (select 1
from sysobjects
where id = object_id('TB_STORAGE')
and type = 'U')
drop table TB_STORAGE
go
if exists (select 1
from sysindexes
where id = object_id('TB_SUPPLY')
and name = 'Relationship_12_FK'
and indid > 0
and indid < 255)
drop index TB_SUPPLY.Relationship_12_FK
go
if exists (select 1
from sysindexes
where id = object_id('TB_SUPPLY')
and name = 'Relationship_11_FK'
and indid > 0
and indid < 255)
drop index TB_SUPPLY.Relationship_11_FK
go
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -