liquibase - Can we refer to a column from sysconstraints using name in sybase? -

since option of accessing via 'name' attribute possible via

sysobjects

, same possible

sysconstraints/syscolumns??

because have not given id attribute table or column or constraints.

sysobjects not contains column name. don't understand first statement. if have table name , want display sysconstraints table table name , column name can have join :

select constrid sysconstraints sc   join sysobjects o on o.id = sc.tableid   join syscolumns c on c.colid = sc.colid , c.id = o.id o.name = 'tablename' , c.name = 'columnname' 

the sysconstraints has colid , tableid columns match syscolumns.colid , sysobjects.id.