Question : I want to have a dynamic query that I can concatenate my table based on current month. I […]
Tag: table
Full table scan even after adding index
Question : i have two tables in Oracle 11g server one is partitioned and another is having a 3GB of […]
Adding multiple foreign keys to single table
Question : I’m trying to add multiple foreign keys to the same table; however, the error code 1215: Cannot add […]
How to design two tables: A hasMany B, and one B per A has state ‘active’?
Question : Figure two tables: environments and branches. Their relationship is: one environment has many branches. This is easy with […]
Mysql Create table shows ERROR 1005 errno 150
Question : I am trying to make a junction table, but I getting a ERROR 1005 errno 150 CREATE TABLE […]
copy a sqlite3 table preserving custom _id
Question : I’m trying to copy a table whose _id field is given by integers with some gaps, e.g. 1,2,5,7, […]
In a one-to-one relationship, where should the foreign key be placed?
Question : I am currently designing an ERD for a project management system. I am unable to choose between two […]
Computed Column Bit based on other Bit Columns
Question : What would be the formula to compute a bit column from other bit columns? For example: CREATE TABLE […]
What does GRANT CONTROL on a schema do in MSSQL?
Question : I’m using SQL Server 2016 for these tests. The following did not allow me to create a table […]
Get number of deleted pages in PostgreSQL table/index?
Question : How can I get the number of deleted pages in a table or index? My purpose in asking […]