Creating a new table

[Guest]

hi:
How do I create a table from an sql command?

I pass a select command "select col1,col2 from ......"
and I want to create a new table.
Is any class for this ?

Thanks

 

[John Smith]

The SQL syntax for CREATE TABLE is

CREATE TABLE "table_name"
("column 1" "data_type_for_column_1",
"column 2" "data_type_for_column_2",
.... )

So, if we are to create the customer table specified as above, we may type
in

CREATE TABLE customer
(First_Name char(50),
Last_Name char(50),
Address char(50),
City char(50),
Country char(25),
Birth_Date date)

 

[Guest]

Thanks John, I was looking for some sort of a class. where we pass parameters .
but otherwise I will use SQL to accomplish this task.
thanks again

 

[Matt]

John,

Is there an SQL command to create a table if the table doesn't already
exist?

Thanks,
Matt

 

[John Smith]

Taken From: http://www.dbforums.com/showthread.php?p=4281279#post4281279

depends on which language you're using
SQL itself has no IF statement
Transact-SQL has, PL/SQL has, but not SQL

here are some interesting links on how to determine if a table exists or
not..

www.aspfaq.com/show.asp?id=2458
www.veign.com/vrc_codeview.asp?type=app&id=101
www.veign.com/vrc_codeview.asp?type=app&id=102

 

[John Smith]

You can create your own class, but the SQL Statement would be the basis of
your class (the part that actually creates the table). Create a loop to
collect the Columns and add it to the SQL Statement.

 

[Herfried K. Wagner [MVP]]

How do I create a table from an sql command?

Which DBMS do you use?

 

[Cor Ligthert]

Raulavi,

Add this as an answer to your original question next time. My answer would
not have changed, however than I had seen it.

Thanks in advance.

Cor

 

[John Smith]

That's a standard SQL command. I use anywhere from MS Access to MS SQL
Server.