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

How do I run a sql query in pgadmin 4?

0 Answers  


What is sqlerrd?

0 Answers  


Is oracle sql free?

0 Answers  


How you can copy a file to file content and file to pl/sql table in advance pl/sql?

0 Answers  


Why do we need databases?

0 Answers  






How packaged procedures and functions are called from the following?

2 Answers  


What is a unique key and primary key and foreign key?

0 Answers  


How do you write a complex sql query?

0 Answers  


Why are indexes and views important to an organization?

0 Answers  


write a query to delete similar records in particular fields(columns) in different tables

6 Answers   TCS,


What is left inner join in sql?

0 Answers  


Query for second maximum salary in each in each department

15 Answers   DST Global Solutions, TCS,


Categories