Interested to Buy Any Domain ? << Click Here >> for more details...
what command is used to create a table by copying the
structure of another table including constraints ?
- 6 Answers
- 16184 Views
- CMC, eicc, I also Faced
- E-Mail Answers
Answer Posted / selvaraj v , anna univ coe
To Use same database :
======================
CREATE TABLE NEW_TBLNAME AS SELECT * FROM OLD_TBLNAME WHERE
1=2;
EXAMPLE :
---------
CREATE Emp_tbl2 AS SELECT * FROM Employee_Tbl1 WHERE 1=2;
Table creation From One USER To Another USER :
======================================================
COPY FROM coeot1a2/coeot1a2@coeau TO scott/tiger@server1
CREATE s11 USING SELECT * FROM major_List;
coeot1a2 ----> USER NAME
coeot1a2 ----> PASSWORD
coeau -------> SERVER NAME
scott -------> Another USER NAME
tiger -------> Another User PASSWORD
server1 -----> Another SERVER NAME
| Is This Answer Correct ? | 1 Yes | 6 No |
Post New Answer View All Answers
What is a record in a database?
How do you explain an index?
how to write date and time literals? : Sql dba
What is cursor in pl sql?
What is sql entity?
Which software is used for pl sql programming?
What is the best sql course?
What is fmtonly in sql?
How do I create a sql database?
How do I run sql profiler?
Why is the cursor important?
What is sqlexception in java?
What is cursor in pl sql with examples?
What is row_number () in sql?
Can we commit in trigger?
