UAT testing on new forums has started. In addition, a large internal bug hunt from random RG people last week found a few usability, and a few security, issues.

Work is...

ZZartin (11/30/2016)

---

But tables aren't source code they're part of the infrastructure of the system.

...

Trying to manage that with complete table replaces would be a nightmare compared to just...

I hear what you're saying, but I'm not hung up on titles. I was trying (perhaps poorly) to make the point that we want to try and hire people that...

Jeff Moden (11/29/2016)

---

[

It's a lot more difficult than just altering a table to alter a single column. The reason why tables are handled differently than store procedures, functions, and...

Iwas Bornready (11/30/2016)

---

My dad was a used care salesman (an honest one).

Does it really matter how the code is written as long as the finished product functions in a way...

jasona.work (11/30/2016)

---

The problem with covering such situations, or trying to enforce "ethical" behavior by laws is, people will ALWAYS find ways to skirt those laws without breaking them. So,...

roger.plowman (11/30/2016)

---

This is a VERY tricky subject.

First, because ethics are subjective. They are *concepts* and as our deplorably litigious society proves, ethics are fluid and mean exactly what the...

Pascal J v Vuuren (11/30/2016)

---

Major changes always goes to those living documents first before we even touch the code and whenever we build new features this is our starting point...

David.Poole (11/30/2016)

---

What I'd like to see is a framework to support whistle blowers.

By all means insist on evidence but whistle blowers need protection. Most companies have a whistle blower...

If you're treating code like code, then you'd always have the definition of the table....

ZZartin (11/29/2016)

---

What about cases where you don't necessarily want to sync up the tables exactly, there's advantages to having a simple make tables match kind of command but unlike stored...

Nelson Petersen (11/29/2016)

---

No need to specify all the columns when you only want to change one of them:

create table test9 (c1 number, c2 number, c3 varchar2(26), c4 varchar2(14) );

Table created.

alter...

t.franz (11/29/2016)

---

@steve-2: What would you do regarding the column order, when you are facing a CREATE OR ALTER <table> statement and the column order differs from the real. Recreating could...

Not for tables.

t.franz (11/29/2016)

---

I doubt, that an ALTER OR CREATE <table> would be used commonly, particularly since a CREATE table will usually need some indexes, FKs, CHECK CONSTRAINTs and some other stuff...