How do I create multiple tables in sqlite3?

Question

2.00/5 (1 vote)

See more:

Is this permissible in sqlite3;

C++

sql = "CREATE TABLE IF NOT EXISTS STUDENTS(" \
"ID INT PRIMARY KEY NOT NULL," \    //primary key
"OBJECT_NAME TEXT NOT NULL," \      //The student object's name
"OBJECT_TYPE TEXT NOT NULL," \      //A student                             
"OBJECT_VALUE TEXT NOT NULL);"\

"CREATE TABLE IF NOT EXISTS GRADE("\//GRADE table
"ID INT PRIMARY KEY NOT NULL,"\           
"OBJECT_TYPE TEXT NOT NULL,"  \     //grade
"OBJECT_VALUE TEXT NOT NULL);";     //grade value

or do I have to do it separately?

C++

sql = "CREATE TABLE IF NOT EXISTS STUDENT(" \
"ID INT PRIMARY KEY NOT NULL," \    //primary key
"OBJECT_NAME TEXT NOT NULL," \      //The student object's name
"OBJECT_TYPE TEXT NOT NULL," \      //A student                             
"OBJECT_VALUE TEXT NOT NULL);";

sql = "CREATE TABLE IF NOT EXISTS TABLE("\//GRADE table
"ID INT PRIMARY KEY NOT NULL,"\           
"OBJECT_TYPE TEXT NOT NULL,"  \     //grade
"OBJECT_VALUE TEXT NOT NULL);";     //grade value

Thanks in advance.

Posted 23-Nov-14 12:59pm

pyler

Add a Solution

2 solutions

Solution 2

Hi Friend

here i am showing you how its works in sql

Like that way u can use in sqlite3 also

SQL

Declare @Str nvarchar(Max)
set @Str='Create table TempSample (Sno int,Data Nvarchar(50));
drop TABLE TempSample;
Create table TempSample1 (Sno int,Data Nvarchar(50));
drop TABLE TempSample1;'

EXEC(@Str)

Posted 23-Nov-14 20:10pm

lokesh lokesh

Comments

Richard MacCutchan 24-Nov-14 4:47am

That doesn't work in SQLite.

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Mehdi Gholam · Accepted Answer · 2014-11-23T18:46:00

Solution 1

Do it separately that way you can check for errors each time and you know what went wrong and where.

Posted 23-Nov-14 18:46pm

Mehdi Gholam