What are the steps to follow when preparing to create a table?

Question added by Emad Mohammed said abdalla , ERP & IT Software, operation general manager . , AL DOHA Company
Date Posted: 2015/01/07

Upvote (0) Views (2) Followers (1) Answers (1) Report Question

Write an Answer
Register now or log in to answer.

by Vinod Jetley , Assistant General Manager , State Bank of India

The create table statement is used to create a new table. Here is the format of a simple create table statement:

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

Format of create table if you were to use optional constraints:

create table "tablename" ("column1" "data type" [constraint], "column2" "data type" [constraint], "column3" "data type" [constraint]); [ ] = optional

Note: You may have as many columns as you'd like, and the constraints are optional.

Upvote (0)

Downvote Reply () Report

I'm on the first step for preparing a voip project in my business, how can you help me so I can start on good bases?
Top Answer: Thank you for your support, and to be well precie my first choice for voip solution is a Cisco solutionSo ... See More

Answers (4)
What are the steps in preparing a budget for a business? Pls. send clear detailed explanation
Top Answer: <p>Creating, monitoring and managing a budget is key to business success. It should help you alloca ... See More

Answers (2)
What are the steps to prepare chemical ammonia?
Top Answer: il fallait suivre le procéde de haber bosh en faisant réagir le N2 avec H2 See More

Answers (1)
What are the steps in preparing budgets?
Top Answer: We make budget for the whole company with production,material consumotion,expenses and forecast the budge ... See More

Answers (2)

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.

Get Help