Love Sun

Sybase怎样查询一张表中的某个字段是否定义为 not null

status != 8
syscolumns表里status的值等于8即为允许为空值.

sp_helptext table_name
就可以看到表的定义

Tagged on:

Leave a Reply

Your email address will not be published. Required fields are marked *