Re: VARCHAR DEFAULT 'user' to record current user name

[Stephen Aberle]

Update: Found it, kind of. But not quite, not really.

I had a look at the INFORMATION_SCHEMA.COLUMNS information for my UserName columns. The columns that work correctly are defined with COLUMN_DEFAULT = user(), while the ones that don't work have COLUMN_DEFAULT = 'user'. For the life of me I can't remember what it was that I did to get that user() value in there as the default. When I try (using Heidi) to set it as user() or User(), I just get the quoted string 'user()' or 'User()'.

So I tried using ALTER TABLE:

ALTER TABLE MyTableName
ALTER COLUMN UserName SET DEFAULT user();

-- and of course it works! But my question remains: How did I get that user() value in there to begin with? I'm sure I was using the Heidi table designer to do it. Does it only work when you first define the table? the column??