depending on what DB model you're using something like the following should apply
CREATE TABLE [name of table] (columnname DATATYPE ([size or length]) [attriubutes], nextcolumnname DATATYPE ([size]) attributes);
so for example, using a mySQL database
CREATE TABLE users (user_id INT AUTO_INCREMENT NOT NULL, PRIMARY KEY(user_id), firstname VARCHAR (50))
THis will create a table called users with two columns. user_id is defined as the primary key and has an INT data type and firstname is a variable length field which can hold upto 50 characters.
See your DB documentation to see exactly what datatypes and attributes it supports.
Max
-----Original Message-----
From: John Petraitis [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 17, 2000 10:51 AM
To: [EMAIL PROTECTED]
Subject: Creating database tables with SQL: wasn't there a KB article?
I can't seem to find the KB article which goes through creating new database
tables just using SQL statements. I've seen it once, but I don't remenber
if there were driver limitations, or how to set it the files up in
Administrator. Any clues?
Thanks.
________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/
To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
