Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
Nick_Kit
Starting Member
1 Post |
Posted - 2014-07-20 : 07:16:07
|
DROP TABLE BookAuthor;DROP TABLE BookPublisher;DROP TABLE Book;DROP TABLE Loan;DROP TABLE Author;DROP TABLE Publisher;DROP TABLE Student;CREATE TABLE Student( Stud_id VARCHAR(10) NOT NULL, Stud_name VARCHAR(50), course CHAR(10), gender CHAR(5), address VARCHAR(50), city VARCHAR(10), e-mail varchar(20),primary key (Stud_id));CREATE TABLE Publisher( pub_id VARCHAR(10) NOT NULL, pub_name VARCHAR(50), pub_address VARCHAR(50), pub_contact_No VARCHAR(12), pub_email VARCHAR(20),primary key (pub_id));CREATE TABLE Author( author_id VARCHAR(10) NOT NULL, author_name VARCHAR(50), author_address VARCHAR(50),nick |
|
bitsmed
Aged Yak Warrior
545 Posts |
Posted - 2014-07-20 : 11:51:33
|
1) Please post the error you receive2) SQL looks incomplete. Please post the relevant SQL you are having trouble with |
|
|
|
|
|
|
|