create
database
Myth
use
Myth
go
--1
create
table
Branches
(
BranchID
int
primary
key
not
null,
ChineseName
varchar
(
200
)
not
null,
EnglishName
varchar
(
200
)
not
null,
City
varchar
(
200
)
not
null,
RegisteredCapital
nvarchar
(
20
)
not
null,
CompanyDirector
varchar
(
200
)
not
null,
ChineseAddress
varchar
(
200
)
not
null,
EnglishAddress
varchar
(
200
)
not
null,
TheFrontDeskPhone
nvarchar
(
20
)
not
null,
LegalRepresentative
varchar
(
20
)
not
null,
Remarks
nvarchar
(
200
)
)
insert
Branches
values
(
1
,
'
神话北京分公司
'
,
'Myth Beijing branch'