Guys I need a little bit support on this:
My question is related to the following table:
In the table, I have to create an item that is a meaningless primary key called ''banr''. I need a SQL script that makes this change. I have to use Alter and Drop statements, but I really do not know how I can use ALTER and DROP?
The uniqueness rule for the columns Order, article should be retained.
I think that I have to follow these steps but i am not sure and don't know what is the best way and how it will look like.
1. Create a new table with primary key or ID with name ''banr'' with AUTOINCREMENT and which is meaningles, + other fields.
2. insert into new_table and select from old table
3. Drop old table
4. rename new table to old table
How can I make this script? How does it looks like? If anyone can help a little way. Many thanks!