关于系统表sysdatabases中的字段意义?

可否讲一下系统表sysdatabases中 status各个值的意思啊,比如是0时,是正常;清说一下其他的。还有type字段的值~~~先谢了
---------------------------------------------------------------

U can get a ref_book about systbl from sybase site
---------------------------------------------------------------

http://www.sybase.com/developer
---------------------------------------------------------------

status 控制位

4 select into/bulkcopy
8 trunc log on chkpt
16 no chkpt on recovery
32 用for load选项创建(或在装载数据库时崩溃)的数据库
256 可疑的数据库,未恢复,无法打开或使用,只能用dbcc dbrepair删除
512 ddl in tran
1024 read only
2048 dbo use only
4096 single user
8192 allow nulls by default

Published At
Categories with 数据库类
comments powered by Disqus