Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
adding table
- Thread starter twcman
- Start date
the SQL syntax for creating database tables:
CREATE TABLE "tableName" ("field1" "data type"[constraint], "field2" "data type"[constraint]);
You may have as many fields as you like and constraints are optional.
example:
CREATE TABLE classdata
(studentNum number(6) unique not null,
firstName varchar(15) not null,
lastName varchar(15) not null,
age number(3),
address varchar(30) ) Sylvano
dsylvano@hotmail.com
"every and each day when I learn something new is a small victory..."
CREATE TABLE "tableName" ("field1" "data type"[constraint], "field2" "data type"[constraint]);
You may have as many fields as you like and constraints are optional.
example:
CREATE TABLE classdata
(studentNum number(6) unique not null,
firstName varchar(15) not null,
lastName varchar(15) not null,
age number(3),
address varchar(30) ) Sylvano
dsylvano@hotmail.com
"every and each day when I learn something new is a small victory..."
- Status
Similar threads
- Locked
- Question