Stack Overflow
Stack Overflow

Questions tagged [system-tables]

59 questions
2
votes
1 answer

List Tables and Table Extended Properties

I want to return a list of all tables within my database along with any related extended properties for the table. This gives me the list of tables: SELECT TABLE_NAME AS tTableName, TABLE_TYPE AS tTableType FROM information_schema.tables AS…
Joe Falcon
  • 95
  • 1
  • 1
  • 5
2
votes
1 answer

Which postgres system table stores a map of PIDs to session authorizations?

I want to look further into the PIDs listed in pg_stat_activity to know what their last succesful call to SET SESSION AUTHORIZATION set their session authorization to. Which table or view do I need on PostgreSQL 9.0?
Kev
  • 15,899
  • 15
  • 79
  • 112
1
vote
1 answer

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

I use a select from StackOverflow: How can I get the table description (fields and types) from Firebird with dbExpress to get schema-data of Firebird databases. However, this select does not show the name of the domain that is assigned to a…
Bastian Blanc
  • 41
  • 4
1
vote
1 answer

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

I'm currently working on a script which writes metadata to system tables of an SAP HANA database. For one example, I need to differentiate between a HANA database with an Support Package Stack of version 05 or higher. Is there any system table I can…
Andi90
  • 13
  • 3
1
vote
2 answers

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

Given a table, let's call it performance6a - with table structure >> student_id | math | history | language | science table content - performance6a I need to write a query which produces a report as below - expected query output The group count is…
NoCodeDefFound
  • 13
  • 6
1
vote
1 answer

SQL Server to check all columns in a databases views for a specific string value

My employer has a third party application that has a very complex set of obliquely named views. I am trying to locate the views that contain specific data that is entered in the applications UI. I have SQL to build a CTE with all view names and…
MWest
  • 13
  • 4
1
vote
1 answer

How to find when was table Last Truncated in Sybase? Any system table containing that Info

Hi All Sybase Experts And Coders, I have a strange requirement to find out when my Tables in database was last truncated? Is there any way to find out using any of the systemtables in sybase. If Answer to above is No, then any solution to implement…
Prashant
  • 11
  • 3
1
vote
1 answer

How to get proper column types in Sybase

I have to know the data type of some columns in my table in Sybase ASE. Here is my query select name from systypes where type in (39, 47, 39, 39, 106 ) this returns char varchar sysname nchar nvarchar decimaln …
AbtPst
  • 7,778
  • 17
  • 91
  • 172
1
vote
1 answer

What privileges do you need to access sys.$ tables?

What privileges do you need to be able to query the sys.obj$, sys.col$ etc system tables directly?
thecoop
  • 45,220
  • 19
  • 132
  • 189
1
vote
2 answers

MS Sql Server Object Creation / Alter Script

In Sql Server when you select to modify a SP or UDF it loads the objects alter query in a query window. Are these queries accessible in a system table so I can store the alter statements somewhere? It looks like syscomments has some objects but not…
Chris Klepeis
  • 9,783
  • 16
  • 83
  • 149
1
vote
1 answer

Including system tables in SQL Server Management Studio generated scripts

I'm currently facing a problem when scripting my development db with SQL Server Management Studio. I'm developing an application using EF5 code first and I'm constantly moving my development db from one machine to the other. The method I'm using to…
jcgalveza
  • 371
  • 5
  • 13
1
vote
2 answers

bobj system tables

I am new to BOBJ reporting and I am trying to generate a data dictioanry for BOBJ reports , like what universe does a report look into, what object does a report column refer and what tabel in the DB does this report column inturn refer.. such kind…
shiny sherbina
  • 25
  • 3
1
vote
2 answers

SQL Server meta data table and column descrption

Possible Duplicate: SQL Server: Extract Table Meta-Data (description, fields and their data types) I just like to ask if there is a way to programmatically retrieve table and column descriptions from SQL Server 2008? These are the descriptions…
dinoD
  • 35
  • 1
  • 6
1
vote
2 answers

mysql: Cant we create triggers on system tables?

I am trying to audit the privilege changes in mysql.user table by writing a trigger on it. insert trigger: will capture who gave the new permissions and when update trigger: will capture who changes the privileges from what[old privilege] remove…
Uday
  • 1,480
  • 4
  • 27
  • 44
0
votes
1 answer

umbraco and custom system table

I have the following scenario: My website db has a system table called "Companies", which includes an id field, companyName field, and companyImageUrl field. How do I set up an umbraco document type for adding entries to this table ? Maybe I…
user560498
  • 537
  • 1
  • 16
  • 25
1
2
3 4