what command is used to create a table by copying the
structure of another table including constraints ?

Answers were Sorted based on User's Feedback



what command is used to create a table by copying the structure of another table including constra..

Answer / a.jyothsna

I know copying the structure of one table but not the
constraints also:
create table newtablename as
select * from oldtablename;

with the above query total data will also be copied.
But to copy only the structure.

create table newtablename as
select * from oldtablename
where 1=2;

Is This Answer Correct ?    20 Yes 6 No

what command is used to create a table by copying the structure of another table including constra..

Answer / saurabh agrawal

We can only copy the structure of the table and not the
constraints.
Syntax is as below:
Create table newtablename as select * from oldtablename;

In this way only NOT NULL constraint specified on any
column of the OLDTABLE will automatically get copied into
the NEWTABLE but other constraint will have to be created
manually.

Is This Answer Correct ?    11 Yes 1 No

what command is used to create a table by copying the structure of another table including constra..

Answer / ben

crete view (view_name) as
select * from (table);

In SQL, a view is a virtual table based on the result-set of an SQL statement.

A view contains rows and columns, just like a real table. The fields in a view are fields from one or more real tables in the database.

i think this is the right answer

:)

Is This Answer Correct ?    1 Yes 1 No

what command is used to create a table by copying the structure of another table including constra..

Answer / anksuh

SELECT TOP 0 * INTO employee2 FROM dbo.employeedtls
using this command we can copying the structure of one table

Is This Answer Correct ?    0 Yes 0 No

what command is used to create a table by copying the structure of another table including constra..

Answer / 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

what command is used to create a table by copying the structure of another table including constra..

Answer / thirumal

select * into <new table name> from < old tablename> where
<any false condition>
ex: new table name "emp"
Old table name "dept"
select * into emp from dept where 2=5
then it will display only the structure of the old
table,not the data

Is This Answer Correct ?    3 Yes 15 No

Post New Answer



More SQL PLSQL Interview Questions

What are the limitations of sql express?

0 Answers  


how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba

0 Answers  


how to drop an existing index in mysql? : Sql dba

0 Answers  


there are .......different types of serializability

1 Answers   Wipro,


What is the maximum number of triggers, you can apply on a single table?

0 Answers  






What is bitemporal narrowing?

0 Answers  


What is memory optimized table?

0 Answers  


Define tables and fields in a database

0 Answers  


why use cursors?

5 Answers   Oracle,


What is function and procedure?

0 Answers  


what is the difference between group by and order by in sql? : Sql dba

0 Answers  


What are the syntax and use of the coalesce function?

0 Answers  






Categories