Programatically checking Allows Null property of a column

[bmcallister]

SQL such as the following returns the Allows Null property of a column in SQL Server:

select is_nullable from information_schema.columns where 
  table_name = 'TheTableName' and 
  column_name = 'TheColumnName'
 

I need to do the same in MS Access and have tried the following:

select ColumnProperty( Object_ID('TheTableName'), 'TheColumnName',
'AllowsNull')

I get the error: 'Undefined function ColumnProperty in expression'.

I am programming in Delphi (using a TADOQuery) with an Access97 database.

Any clues would be much appreciated.

[RedSon]

Maybe the nice folks in mySQL can be of assistance. To the folks in mySQL, let me know if I should have moved it elsewhere ;-)

[pbmods]

Heya, bmcallister. Welcome to TSDN!

Please use CODE tags when posting source code:

[CODE=sql]
SQL code goes here.
[/CODE]

I'm going to go ahead and move this thread to the Access forum, where our resident Experts will be better able to help you out.

[FishVal]

Hi, there.

I'm not sure JetSQL supports something like you are expecting.
Here is example of how it may be done in VBA via Access object model.

Public Function GetFieldRequiredProperty(txtTable As String, _
                                         txtField As String) As Boolean
 
    GetFieldRequiredProperty = _
        CurrentDb.TableDefs(txtTable).Fields(txtField).Required
 
End Function