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

This article will explain in detail how to query the sql statements of which object and what fields in the database. The editor thinks it is very practical, so I share it with you as a reference. I hope you can get something after reading this article.

The database queries which object contains what fields to write:

Select * from sysobjects o, syscomments swhere o.id = s.idand text like'% text%'and o.xtype ='P'

Change text to the field to be checked.

The database queries which object contains tables.

Select o.name from sys.all_sql_modules sJournal sysobjects o where definition like'% table name% 'and o.id = s.object_id

Change the table name to the table name you need to look up

This is the end of the article on "how to query the sql statement of which object contains what fields". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, please share it for more people to see.

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.