what command is used to create a table by copying the
structure of another table including constraints ?
- 6 Answers
- 15162 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 database sql?
how many sql ddl commands are supported by 'mysql'? : Sql dba
how to drop an existing view in mysql? : Sql dba
Can we enter data in a table in design view?
What is data profiling in sql?
Why is there a need for sqlcode and sqlerrm variables?
What are different types of statements supported by sql?
What is example of database?
What are the types of index in sql?
What is the difference between nvl function, ifnull function, and isnull function?
Does varchar need length?
What is bulk compiling in pl/sql.?
what is row? : Sql dba
Explain the update statement in sql
Is delete faster than truncate?
