Shulou(Shulou.com)06/01 Report--

I. list the database

1. List all libraries

Use master;goselect name,dbid from master.dbo.sysdatabases

two。 List only user libraries

Use master;goselect name,dbid from master.dbo.sysdatabases where dbid > 4

List the tables in the library

1. List only the system tables in the library

Use DB_NAME;goselect name,xtype from sysobjects where xtype ='s'

two。 List only the user data tables in the library

Use DB_NAME;goselect name,xtype from sysobjects where xtype ='u'

Note: DB_NAME refers to the name of the user's database

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.