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
- 16636 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
How can I speed up sql query?
how many sql dml commands are supported by 'mysql'? : Sql dba
What are sql objects?
how to concatenate two character strings? : Sql dba
What are pl/sql cursor exceptions?
What is trigger and stored procedure in sql?
State few characteristics of pl/sql?
How many sql are there?
how to create a table index in mysql? : Sql dba
What is number function in sql?
How to process query result in pl/sql?
Which is faster truncate or drop?
What is localdb mssqllocaldb?
What is the advantage of nosql?
What is the difference between in and between in sql?
