查詢(xún)數(shù)據(jù)庫(kù)中所有用戶(hù)表或表的個(gè)數(shù)

查詢(xún)數(shù)據(jù)庫(kù)db1中所有的用戶(hù)表
    use db1
    go
    select * from sysobjects where type = ’U’
    系統(tǒng)表的個(gè)數(shù)
    select count(*) from sysobjects where type = ’S’
    存儲(chǔ)過(guò)程：type = ’P’
    視圖： type = ’V’