Shulou(Shulou.com)05/31 Report--

Today, I will talk to you about the sql statement about how to query the number and name of TABLE in the database in SQL Server. Many people may not understand it very well. In order to make you understand better, the editor has summarized the following content for you. I hope you can get something according to this article.

There is a system-generated table sysobjects in every database in SQL Server, and all the table names in database are recorded in this table. We can query using the following SQL syntax.

The code is as follows:

Select Name,id from sysobjects where xtype ='U'

Xtype='U' represents the table used, and if xtype='S' is used, it represents the default table of the system

There is also a table named syscolumns in the system table who records the field data. if you want to find out the relevant information about a certain table field, you can use the following SQL syntax.

The code is as follows:

Select Name from syscolumns where id in (Select id from sysobjects where name= 'Table_name' and xtype='U')

After reading the above, do you have any further understanding of the sql statement on how to query the number and name of TABLE in the database in SQL Server? If you want to know more knowledge or related content, please follow the industry information channel, thank you for your support.

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.