Can anyone tell me what this SQL does

W

wcprog

I inherited some legacy code using a Jet 4.0 database that I'm trying to
refactor. I found this SQL statement, and for the life of me can't figure
out what it does:

ALTER TABLE [Location] ALTER COLUMN [Location_Address] SET DEFAULT

Now I know what it should do if there were a value of some sort after the
SET DEFAULT statement, but there is no value.

Any ideas anyone?

Thanks,
wcprog
 
M

Michel Walsh

Hi,


It removes the default value for the specified field, specified table.


Hoping it may help,
Vanderghast, Access MVP
 
W

wcprog

That makes sense.

Does this in any way differ from "DROP DEFAULT"?

Michel Walsh said:
Hi,


It removes the default value for the specified field, specified table.


Hoping it may help,
Vanderghast, Access MVP


wcprog said:
I inherited some legacy code using a Jet 4.0 database that I'm trying to
refactor. I found this SQL statement, and for the life of me can't figure
out what it does:

ALTER TABLE [Location] ALTER COLUMN [Location_Address] SET DEFAULT

Now I know what it should do if there were a value of some sort after the
SET DEFAULT statement, but there is no value.

Any ideas anyone?

Thanks,
wcprog
Click to expand...
Click to expand...
 
M

Michel Walsh

Hi,


I don't see any difference, at first glance, in the resulting effect,
although DROP DEFAULT sounds more "universally" supported, more
self-documented, easier to maintain, as you experienced ... :)


Vanderghast, Access MVP


wcprog said:
That makes sense.

Does this in any way differ from "DROP DEFAULT"?

Michel Walsh said:
Hi,


It removes the default value for the specified field, specified table.


Hoping it may help,
Vanderghast, Access MVP


wcprog said:
I inherited some legacy code using a Jet 4.0 database that I'm trying to
refactor. I found this SQL statement, and for the life of me can't
figure
out what it does:

ALTER TABLE [Location] ALTER COLUMN [Location_Address] SET DEFAULT

Now I know what it should do if there were a value of some sort after
the
SET DEFAULT statement, but there is no value.

Any ideas anyone?

Thanks,
wcprog
Click to expand...
Click to expand...
Click to expand...
 
W

wcprog

I agree...

Thanks for your help with this!
wcprog


Michel Walsh said:
Hi,


I don't see any difference, at first glance, in the resulting effect,
although DROP DEFAULT sounds more "universally" supported, more
self-documented, easier to maintain, as you experienced ... :)


Vanderghast, Access MVP


wcprog said:
That makes sense.

Does this in any way differ from "DROP DEFAULT"?

Michel Walsh said:
Hi,


It removes the default value for the specified field, specified table.


Hoping it may help,
Vanderghast, Access MVP


I inherited some legacy code using a Jet 4.0 database that I'm trying to
refactor. I found this SQL statement, and for the life of me can't
figure
out what it does:

ALTER TABLE [Location] ALTER COLUMN [Location_Address] SET DEFAULT

Now I know what it should do if there were a value of some sort after
the
SET DEFAULT statement, but there is no value.

Any ideas anyone?

Thanks,
wcprog
Click to expand...
Click to expand...
Click to expand...
 
Top