Let us suppose we have a table with structure in order
empno
empname
empdesig
empcountry
and now i want to re-organize the columns of this table to
empno
empdesig
empname
empcountry
how can i do this with queries ?
assume that table contains the data.
- 3 Answers
- 5774 Views
- I also Faced
- E-Mail Answers
Answer Posted / s. syam sundar
try this
create table emp1 as select
empno,empdesig,empname,empcountry from emp
this would creat a new table named as emp1 and
u can retrive the data from this table as of emp
but constraints,indexs which u have on emp table are
created on this emp1 table
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is raw datatype in sql?
What is dml statement?
how to select unique records from a table? : Sql dba
What is audit logout in sql profiler?
What is a full join sql?
Is sqlite good enough for production?
What is exception? What are the types of exceptions?
What is a field in a database?
What is cascade in sql?
Is sql a dbms?
What is the location of pre_defined_functions.
How subquery works in sql?
What is a pragma statement?
What is normalisation and its types?
Is the primary key an index?
