python (65.1k questions)

javascript (44.2k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (12.9k questions)

Questions - system-tables

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

We continuously gather data from sys.sm_exec_sessions and sys.dm_exec_requests to be able further investigate our locking and performance issues. In some cases, I can see that multiple queries to sys....
test-img

Michal Rizek

sql

sql-server

system-tables

Votes: 0

Answers: 0

Netezza to Redshift Conversion - _v_table and _v_relation_columns alternatives

What are the alternatives for the below Netezza Tables and columns that I could use in Redshift? _v_table (columns used: 'RELVERSION' and 'OBJTYPE') _v_relation_columns (columns used: 'NAME' and 'AT...
test-img

prsng_2022

amazon-redshift

netezza

system-tables

Votes: 0

Answers: 1

Latest Answer

The alternative to Netezza's _v_table could be SVV_ALL_TABLES in Redshift. There's no relversion attribute because tables aren't versioned. (So you don't need to groom versions after adding a column)....
test-img

Jaap van der Herberg

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 ...
test-img

Bastian Blanc

sql

metadata

firebird

system-tables

Votes: 0

Answers: 1

Latest Answer

The column RDB$FIELD_SOURCE in the table RDB$RELATION_FIELDS hold the the field domain name. (@Marcodor) Syntax: RF.RDB$FIELD_SOURCE AS FIELD_DOMAIN,
test-img

Bastian Blanc

Posts

Questions

Blogs

Jobs