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...

henrik staun poulsen (11/29/2016)

---

Steve,

I'm perfectly happy about the enhancement that we got with

DROP TABLE IF EXISTS myTable

CREATE TABLE myTable(...)

This ensures that the table is dropped, so that my Create table...

hakim.ali (11/29/2016)

---

IMHO, even "CREATE or ALTER objectname" can/should be reduced to just "CREATE objectname". Visual Studio database projects / SSDT has had this for years. Just issue the create statement,...