How to create a table from existing table, Database Management System

Assignment Help:

How to create a table from existing table?

Create table as

e.g, To create a new table ‘N_emp' with employee names and their identification numbers only from employee table, statement is to create table N_emp as select empname, empid from employee

Related Discussions:- How to create a table from existing table

Views-data control, Views A view is like a window by which data from ta...

Views A view is like a window by which data from tables can be changed or viewed. The table on which a view is based is known as Base table. The view is stored as a SELECT stat

Define decision tree classifiers, Define decision tree classifiers? As ...

Define decision tree classifiers? As the name suggests decision tree classifiers use a tree: Every leaf node has an associated class, and every internal node has a predicate as

Create a new user-data control, Create a new user : CREATE USER IDENTI...

Create a new user : CREATE USER IDENTIFIED BY Example: //CREATE USER MCA12 IDENTIFIED BY W123 Grant: It is used to give database access permission to users. It is of

Explain sorted file with advantages, Explain sorted File with advantages? ...

Explain sorted File with advantages? Sorted file The sort utility shall perform one of the subsequent functions: 1.Sort lines of all the named files together and write the

Cases of constraint violations, (1) Insert into PERSON Violated con...

(1) Insert into PERSON Violated constraint: - Key constraint Reason: - Primary key 1 already exists in PERSON. Dealing: - DBMS could ask the user to provide valid PER

Order by clause-data manipulation language, Order by clause By usin...

Order by clause By using this rows can be sorted It is used in the last portion of select statement By default it gets ascending order DESC: is used

Participation constraints, explain participation constraints with examples

explain participation constraints with examples

Visio diagram - database, The database depicted in the Visio diagram descri...

The database depicted in the Visio diagram describes Proceeding , Article , Researcher , article PublishedIn a proceeding, article WrittenBy researchers and proceedings Edi

Define a view and a trigger, Define a view and a trigger. Construct a view ...

Define a view and a trigger. Construct a view for the above relations that have the information about suppliers and the elements they supply. The view holds the S#, SNAME, P# , PNA

State the meaning of object representation, State the meaning of Object Rep...

State the meaning of Object Representation The term object representation means "to represent object with the help of objects model symbols". Implementing objects is too simp

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages