what command is used to create a table by copying the
structure of another table including constraints ?
- 6 Answers
- 14205 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 do I create a sql database?
What are sql functions? Describe in brief different types of sql functions?
Explain spool.
how to use case expression? : Sql dba
what's the difference between a primary key and a unique key? : Sql dba
how to include character strings in sql statements? : Sql dba
What are the built in functions of sql?
What is the basic structure of an sql?
What is offset in sql query?
What are sql commands?
Does sap use sql?
Is merge a dml statement?
Does access use sql?
What is field delimiter?
Why is normalization important?
