Can anyone tell me what this SQL does?

[jv6886]

I inherited some legacy code 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

 

[jv6886]

By the way, its for a Jet 4.0 database.

wcprog

 

[PHV]

And this SQL executes without error on a Jet 4.0 database ?

 

[jv6886]

Yes. It's actually a whole series of the same statement, but specifying different tables and fields.

 

[PHV]

In ac2003 I get a syntax error ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[jv6886]

Actually I'm running this from Visual Basic 6 using ADO. In stepping through it I'm not getting any errors. The code snippit is as follows:

strSQL = "ALTER TABLE [Location] " & _
         "ALTER COLUMN [Location_Address] " & _
         "SET DEFAULT"
    
Call CON.Execute(strSQL)

I just tried another test case, and it appeared to reset the default--in this case from a text string to nothing.

 

[alvechurchdata]

it appeared to reset the default--in this case from a text string to nothing

There must be a subtle difference between this and DROP DEFAULT. I suppose this sets the default to an empty string rather than to Null.

Geoff Franklin

http://www.alvechurchdata.co.uk