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
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 |
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 |
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 |
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 |
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 |
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 |
How do I run a sql query in pgadmin 4?
What is sqlerrd?
Is oracle sql free?
How you can copy a file to file content and file to pl/sql table in advance pl/sql?
Why do we need databases?
How packaged procedures and functions are called from the following?
What is a unique key and primary key and foreign key?
How do you write a complex sql query?
Why are indexes and views important to an organization?
write a query to delete similar records in particular fields(columns) in different tables
What is left inner join in sql?
Query for second maximum salary in each in each department
15 Answers DST Global Solutions, TCS,