"t53864" <t5****@yahoo.com> wrote in message
news:9e**************************@posting.google.c om...
| I need to reorder the primary key of a table. Say,
|
| Primary Key (field1, field2)
|
| changed to:
|
| Primary Key (field2, field1)
|
| Would like to know if this creates any problem to the
| database?
sort of -- all FKs would be dropped when the PK is dropped, and then
recreated with the new column order explicitly indicated
"Mark C. Stock" <mcstockX@Xenquery .com> wrote in message news:<T9********************@comcast.com>...
"t53864" <t5****@yahoo.com> wrote in message news:9e**************************@posting.google.c om... | I need to reorder the primary key of a table. Say, | | Primary Key (field1, field2) | | changed to: | | Primary Key (field2, field1) | | Would like to know if this creates any problem to the | database?
sort of -- all FKs would be dropped when the PK is dropped, and then recreated with the new column order explicitly indicated
do a little testing to see the effects
++ mcs
To clarify what Mark said if you attempt to drop a PK that is
referenced by a FK Oracle will return an error and refuse to perform
the drop unless you include the cascade constraints cluase. However,
it is your responsibility to re-create the dropped FK references.
Oracle does not automatically restore them in versions 7.0 - 9.2, and
I doubt that this has changed with 10g.
If there are no FK references to the PK then this is not a
consideration.
>[Case1] Primary Key (field1, field2)
index for (field1, field2) or (field2, field1) or *(field1)*.
[Case2] Primary Key (field2, field1)
index for (field1, field2) or (field2, field1) or *(field2)*.
so, If you query with condition (field1, field2) <- order doesn't matter
[Case1] and [Case2] should be the same, I think.
In case query with (field1) or (field2) only,
only [Case1] or [Case2] will be available.
Hi,
I'm working with the MSSQL 2000 and C#.
When I load my data from the database table in a DataSet I use the query to
order all records by some column. Then I can work with these records,...
Is it possible to reorder items in a listbox server control by having the
user select an item and then click an up or down button? ... how?
Or is this something that can only be achieved client...
Reordering Column changes column Indexes????
i use column.index to access(or add ) data in listview. i want to allow user
to reorder columns as they need. So i am afraid to get wrong data when user...
Hello,
I have found a way to easily reorder rows of my listview. But it only
works in small icons mode. When I do my reordering (drag and drop in my
own list) in large icons mode, the item that...
Hi,
Below is a calss with function I gathered from a news group that uses
GetCharacterPlacement API to reorder text.
I have mixed text Hebrew/English and the function reorders the Hebrew text.
...
hello
My question is, after we allow the column reorder can we modify the order of columns through our code.
What I need to do is reorder the listview columns so the first column with the...
Use the Northwind database Products table as an example.
Purchasing dept gets a report showing when inventory items on hand qty are
below the reorder level.
easy enough:
Select ProductID,...
Heres my problem: my javacript code reads each child element e.g.:
<video>
<author>skateboard2</author><id>xqWBGvbvw7g</id><title>zach skating</title><length_seconds>100</length_seconds></video>...
I need to reorder the primary key of a table. Say,
Primary Key (field1, field2)
changed to:
Primary Key (field2, field1)
Would like to know if this creates any problem to the
database?
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...