Opensource ERP Java 2016

Recommented

opentaps

opentaps Open Source ERP CRM ecommerce Warehouse Inventory Financials Accounting Purchasing Supply Chain Management Business Intelligence

www.opentaps.org/
Download opentaps

SQL queries create table example sql command to create table

We can Create table with SQL command for example code below

CREATE TABLE table_name(
  column_name1 data_type(size),
  column_name2 data_type(size),
  column_name3 data_type(size));

Example SQL code for create table

CREATE TABLE Student(
   student_id int,
   student_name varchar(255));

Note: with difference DBMS  the command will not the same for example mysql  have datatype varchar but in Oracle use data type Vaarchar2