Can anyone tell me what this SQL does

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Hi,


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


Hoping it may help,
Vanderghast, Access MVP
 
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...
 
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...
 
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...
 
Back
Top