SQL statement used to query the TABLE quantity and name of a database in SQL Server

In SQL Server
Each database has a table generated by the system.
The table sysobjects records all the table names in the database.
We can use the following SQL syntax for query operations.

Copy codeThe Code is as follows:
Select Name, id from sysobjects where xtype = 'U'

Xtype = 'U' indicates the table used. If xtype = 's' is used'
The default table

There is also a table named syscolumns in the system table.
He recorded the column information.
If you want to find the field related information of a table, you can use the following SQL syntax ..

Copy codeThe Code is as follows:
Select Name from syscolumns where id in (Select id from sysobjects where name ='
Table_name 'and xtype = 'U ')