Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Exam
Create table shop(shopid varchar(10),salary int,primary key (sid)); Create table customers(cid varchar(10),cname varchar(10),caddress varchar(10),ccity varchar(15),primary key (cid)); Create table staff(sid varchar(10),sname varchar(10),email varchar(15),shopid varchar(10),salary int,primary key (sid),foreign key(shopid) references shop(shopid)); Create table order(oid varchar(10),odate DATE,shopid varchar(10),cid varchar(10),primary key (oid),foreign key (shopid) references shop(shopid),foreign key (cid) references customers(cid));
run
|
edit
|
history
|
help
0
robot-grading
1
Sum then delete one row - SQL Server 2008 R2
Hierarchy table to exclude root
№5
FIGURA5.4
Primary key and unique key for single column and multi columns
№3
ms sql where ,like
Rename column name using 'sp_rename' command