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;

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.

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

:)

Answer / anksuh

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

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

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

what is a tablespace? : Sql dba

0 Answers  

What is the difference between the conventional and direct path loader? : aql loader

0 Answers  

How to run sql*plus commands in sql developer?

0 Answers  

Why cannot I use bind variables in ddl/scl statements in dynamic sql?

0 Answers  

how to create a test table in your mysql server? : Sql dba

0 Answers  

What is the full form of sql?

1 Answers  

package specification-3 procedures package body-2 procedures will is execute

2 Answers   PWC,

What is a boolean in sql?

0 Answers  

What is a composite primary key?

0 Answers  

Which is faster view or stored procedure?

0 Answers  

select * from emp where sal in(select max(sal) from emp) here there is any limit for in operator how many values accpect ?

2 Answers  

Which one is the Best approach to put code, among Triggers and Procedures? Explain?

1 Answers   Sierra Atlantica,