How can I create a table from another table without copying
any values from the old table?

Answer Posted / tejas wajge

create table emp as select * from project where rownum <1;

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is pivot table in sql?

624


What is sql character function?

618


What is offset and limit in sql?

645


how to add a new column to an existing table in mysql? : Sql dba

677


Why is sql*loader direct path so fast?

690






How do I start sql from command line?

616


What is use of trigger?

590


Mention what is the function that is used to transfer a pl/sql table log to a database table?

574


What is trigger and stored procedure in sql?

656


How do you declare a user-defined exception?

631


what are ddl statements in mysql? : Sql dba

678


What is sql and explain its components?

699


How do you create a db file?

603


How run sql*plus commands that are stored in a local file?

605


Is pl sql better than sql?

639