Get all default values:
Select * from syscolumns c inner join systypes t on c.xusertype=t.xusertype left syscolumns c inner join syscolumns t on c.xusertype=t.xusertype left Join sysproperties p on c.id=p.id and c.colid = p.mallid left join syscomments m on c.default =m.id
Get the default value of a single field:
Select * from syscolumns c inner join systypes t on c.xusertype=t.xusertype left syscolumns c inner join syscolumns t on c.xusertype=t.xusertype left Join sysproperties p on c.id=p.id and c.colid = p.mallid left join syscomments m on c.default =m.id where objectProperty (c.id,’IsUserTable’)=1 and object_name(c.id) = ‘T_good’ and objectProperty (c.id) = ‘T_good’ and C.name = ‘field name’
Read More:
- Error: field * doesn’t have a default value
- Error 1364 (HY000): field ‘SSL_ cipher’ doesn’t have a default value
- Mybatis error “field ‘ID’ doesn’t have a default value”
- PostgreSQL sets the default value of the field to the current year
- In SQLite database, set the default value for the field as the current time
- Warning: failed to get default registry endpoint from daemon
- Error attempting to get column ‘xxxxx’ from result set — after Lombok is annotated with builder, mybatis cannot recognize the correct type of field
- Modify the screen resolution after installing Ubuntu 16.04 (xrandr: Failed to get size of gamma for output default)
- Configure Nvidia graphics card on ubuntu18.04 xrandr Failed to get size of gamma for output default
- Use xx [‘xx ‘] = XX to set field value or does not support field: XXX
- MySQL error: column ‘ID’ in field list is ambiguous
- MySQL advanced — Explanation of ref field in explain information
- Android:Field can be converted to a local varible.
- Cause: java.sql.BatchUpdateException: Unknown column ‘xxx‘ in ‘field list‘
- MySQL unknown column ‘in’ field list ‘solution
- How to Fix mat form field must contain a matformfieldcontrol error
- MySQL error 1054 (42s22) unknown column ‘password’ in ‘field list’
- Solution of duplicate entry ‘value’ for key ‘field name’ in MySQL
- How to Solve mybatis returns null when querying Oracle database with char type field
- New fields in hive table and modification of field comments