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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 I created this library database.I cnt execute it

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 receive
2) SQL looks incomplete. Please post the relevant SQL you are having trouble with
Go to Top of Page
   

- Advertisement -