StackOverflow Questions for Tag: system-tables

markzzz
markzzz

Reputation: 47945

How can I replace master..sp_values (used for months) on this query?

Score: 0

Views: 1265

Answers: 1

Read More
gruber
gruber

Reputation: 29727

Find all tables containing column with specified name

Score: 1799

Views: 4270187

Answers: 37

Read More
insanity
insanity

Reputation: 1178

Need to find how redshift table got loaded

Score: 0

Views: 19

Answers: 0

Read More
Lieven Cardoen
Lieven Cardoen

Reputation: 25959

How to check if a Constraint exists in Sql server?

Score: 347

Views: 544788

Answers: 16

Read More
Vikrant More
Vikrant More

Reputation: 5442

Why there is a difference between sp_helpfile vs sys.master_files?

Score: 1

Views: 977

Answers: 3

Read More
Alexander
Alexander

Reputation: 1

Oracle: Grants for select from SYS.DBMS_LOCK_ALLOCATED

Score: -1

Views: 468

Answers: 1

Read More
Michal Rizek
Michal Rizek

Reputation: 33

SQL Server 2019 - suspicious values in sys.sm_exec_sessions.last_request_end_time

Score: 0

Views: 129

Answers: 0

Read More
prsng_2022
prsng_2022

Reputation: 1

Netezza to Redshift Conversion - _v_table and _v_relation_columns alternatives

Score: 0

Views: 200

Answers: 1

Read More
Bastian Blanc
Bastian Blanc

Reputation: 41

How to get the name of the domain that is assigned to a specific field/column of a table?

Score: 1

Views: 279

Answers: 1

Read More
MaterialGirl
MaterialGirl

Reputation: 393

How to extract Stored Procedure body in Teradata

Score: 3

Views: 16735

Answers: 1

Read More
Sadamh Hussain
Sadamh Hussain

Reputation: 1

how to add new column in pg_class for object creation date dumping

Score: 0

Views: 213

Answers: 2

Read More
Tim
Tim

Reputation: 310

SQL Anywhere query to dig schema structure

Score: 0

Views: 1030

Answers: 1

Read More
Andi90
Andi90

Reputation: 13

How to get the SPS number from a SAP HANA database?

Score: 1

Views: 660

Answers: 1

Read More
Vicky
Vicky

Reputation: 115

The newly created schema and tables are not listed under "Information_schema.columns" table in PostgreSQL

Score: 2

Views: 3915

Answers: 0

Read More
Tajinder
Tajinder

Reputation: 2338

How to join System tables or Information Schema tables with User defined tables in Redshift

Score: 0

Views: 3850

Answers: 1

Read More
dn2301
dn2301

Reputation: 15

Equivalent of SQL Server's SYSPROCESS in POSTGRESQL

Score: 0

Views: 240

Answers: 0

Read More
SQLProfiler
SQLProfiler

Reputation: 111

How to select database name in sys.dm_*

Score: 0

Views: 1638

Answers: 1

Read More
user8554358
user8554358

Reputation:

Extended Events connection_id vs client_connection_id

Score: 0

Views: 1611

Answers: 2

Read More
NoCodeDefFound
NoCodeDefFound

Reputation: 13

SQL - Group count by 2 or more columns using union takes more than 2 seconds

Score: 1

Views: 80

Answers: 2

Read More
Ed Avis
Ed Avis

Reputation: 1492

How to tell whether a column is of sysname type

Score: 0

Views: 902

Answers: 2

Read More
PreviousPage 1Next