[SQL SERVER] SQL statement query lists libraries and tables

I. List of databases

1. List all libraries

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

2. List only user libraries

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

Ii. list tables in a library

1. List only the system tables in the library;

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

2. 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 database;

This article is from the "Margin with Wish" blog, please be sure to keep this source http://281816327.blog.51cto.com/907015/1789107

[SQL SERVER] SQL statement query lists libraries and tables