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

CSS uses radial-gradient to implement coupon styles

This article will introduce how to use radial-gra...

CentOS 6.5 i386 installation MySQL 5.7.18 detailed tutorial

Most people compile MySQL and put it in the syste...

Tutorial on installing Ceph distributed storage with yum under Centos7

Table of contents Preface Configure yum source, e...

Mini Programs use Mini Program Cloud to implement WeChat payment functions

Table of contents 1. Open WeChat Pay 1.1 Affiliat...

Implementation of Docker deployment of web projects

The previous article has installed the docker ser...

Installation and configuration method of Zabbix Agent on Linux platform

Here is a brief summary of the installation and c...

Example of how to implement a 2-column layout in HTML (fixed width on the left, adaptive width on the right)

HTML implements 2-column layout, with fixed width...

JS uses canvas technology to imitate echarts bar chart

Canvas is a new tag in HTML5. You can use js to o...

React nested component construction order

Table of contents In the React official website, ...

How to install Docker on Windows Server 2016

Recently Microsoft released Windows Server 2016, ...

Nginx local directory mapping implementation code example

Sometimes you need to access some static resource...

How to use CocosCreator object pool

Table of contents Preface: Specific operations St...

How to install JDK8 on Windows

1. Download: http://www.oracle.com/technetwork/ja...

Sample code for implementing multiple selection based on nested Table in ElementUI

Preface: I wrote this because I helped my friend ...

Docker installation and deployment example on Linux

After reading the following article, you can depl...