Can anyone tell me what this SQL does

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
 
M

Michel Walsh

Hi,


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


Hoping it may help,
Vanderghast, Access MVP
 
G

Guest

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

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

What is wrong with my sql? 3
SQL - UPDATE statement help.... 7
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Are Jet 4.0 Stored queries faster than sql w/ criteria specified as the record source of a form? 14
ADO SQL Problem 2
Can somebody explain this strange sql statement 8
Update table with values from another table 2
Can anyone translate this SQL statement for me? 2

Top