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

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