Database query which object contains which field method statement

Database query which object contains which field method statement

The database queries which object contains which fields .

select *
from sysobjects o, syscomments s
where o.id = s.id
and text like '%text%'
and o.xtype = 'P'

Replace text with the field you want to search

Database query which object contains the table

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

Replace the table name with the table name you want to query

You may also be interested in:
  • How to associate other tables in the select query field of Oracle database query

<<:  Docker compose custom network to achieve fixed container IP address

>>:  Webpack file packaging error exception

Recommend

MySQL establishes efficient index example analysis

This article uses examples to describe how to cre...

MySQL select, insert, update batch operation statement code examples

In projects, batch operation statements are often...

How to install yum source and upload and download commands rz and sz under CentOS7 (with pictures)

** Detailed graphic instructions for installing y...

How to clear floating example code in css

Overview The framework diagram of this article is...

How to implement an array lazy evaluation library in JavaScript

Table of contents Overview How to achieve it Spec...

Detailed explanation of the principle and function of JavaScript closure

Table of contents Introduction Uses of closures C...

Java uses Apache.POI to export HSSFWorkbook to Excel

Use HSSFWorkbook in Apache.POI to export to Excel...

CSS -webkit-box-orient: vertical property lost after compilation

1. Cause The requirement is to display two lines,...

4 Practical Tips for Web Page Design

Related articles: 9 practical tips for creating we...

A brief discussion on why daemon off is used when running nginx in docker

I'm very happy. When encountering this proble...

MySQL performance optimization index pushdown

Index condition pushdown (ICP) is introduced in M...

25 Vue Tips You Must Know

Table of contents 1. Limit props to type lists 2....

Gradient slide effect implemented by CSS3

Achieve results Code html <div class="css...

Getting Started Guide to MySQL Sharding

Preface Relational databases are more likely to b...

IE6/7 is going to be a mess: empty text node height issue

Preface: Use debugbar to view document code in iet...