CodeLobster IDE
http://codelobster.com/forum/

How to generate a new table in SQL
http://codelobster.com/forum/viewtopic.php?f=3&t=24602
Page 1 of 1

Author:  luanvan24 [ Sat May 18, 2019 9:27 am ]
Post subject:  How to generate a new table in SQL

I need to create a view vCustomerOrders that displays the customer's name, order number, and order date.

What is the best route for this?

Author:  Ragnar [ Fri May 31, 2019 6:54 am ]
Post subject:  Re: How to generate a new table in SQL

the beast way is to learn some SQL syntax, some DBMS theory and practice and a bit of SQL Server Architecture. In other words: RTFM, noob.

Author:  avisawant [ Sat Aug 03, 2019 5:50 am ]
Post subject:  Re: How to generate a new table in SQL

SQL CREATE TABLE statement is used to create table in a database.

If you want to create a table, you should name the table and define its column and each column's data type.

Simple syntax to create table-

create table "tablename"
("column1" "data type",
"column2" "data type",
"column3" "data type",
...
"columnN" "data type");

Page 1 of 1 All times are UTC
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
http://www.phpbb.com/