Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6912 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 sqlservr exe?
What is the location of pre_defined_functions.
What is schema in sql example?
what is user defined functions? : Sql dba
explain the difference between myisam static and myisam dynamic. : Sql dba
What is flag in sql?
What is rownum and rowid?
What are different clauses used in sql?
What is difference between inner join and cross join?
Is sqlite thread safe?
Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)
Is sql easier than java?
what are wild cards used in database for pattern matching ? : Sql dba
What is pl sql architecture?
Can there be more than one function with a similar name in a pl/sql block?
