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

Vue element implements table adding, deleting and modifying data

This article shares the specific code of vue elem...

Introduction to using data URI scheme to embed images in web pages

The data URI scheme allows us to include data in a...

Getting Started: A brief introduction to HTML's basic tags and attributes

HTML is made up of tags and attributes, which are...

Examples of clearfix and clear

This article mainly explains how to use clearfix a...

MySQL Router implements MySQL read-write separation

Table of contents 1. Introduction 2. Configure My...

Share some key interview questions about MySQL index

Preface An index is a data structure that sorts o...

Docker implements container port binding local port

Today, I encountered a small problem that after s...

Linux C log output code template sample code

Preface This article mainly introduces the releva...

A detailed discussion of evaluation strategies in JavaScript

Table of contents A chestnut to cover it Paramete...

The docker container directly runs to obtain the public IP operation through ping

Get the local public IP address through the conta...

Detailed graphic tutorial on installing centos7 virtual machine in Virtualbox

1. Download centos7 Download address: https://mir...

Example of setting up a whitelist in Nginx using the geo module

Original configuration: http { ...... limit_conn_...

Best way to replace the key in json object

JSON (JavaScript Object Notation, JS Object Notat...

MySQL derived table (Derived Table) simple usage example analysis

This article uses an example to describe the simp...

Examples of correct use of interface and type methods in TypeScript

Table of contents Preface interface type Appendix...