About 1,893,569 results (3,060 milliseconds)
deleting a sqlite database
https://groups.google.com/g/sqlalchemy/c/J7W-0OQkoWk Feb 25, 2012 ... with tools.drop_tables removing all tables from the database (using ... Oracle, Postgresql, MSSQL where creates/drops are more expensive.
GoogleSQL data definition language | Spanner | Google Cloud
https://cloud.google.com/spanner/docs/reference/standard-sql/data-definition-language Create, alter, or drop tables in a database. Add, alter, or drop columns in ... After you delete a model definition, all SQL queries referencing the deleted model ...
How to drop a view which is represented by Table instance?
https://groups.google.com/g/sqlalchemy/c/GPkKBvbl3Q4 May 6, 2012 ... do we have round trip tests for all that ? can I reflect a view from Oracle and recreate on SQLite ? the answer is: absolutely not. It would ...
Manage tables | BigQuery | Google Cloud
https://cloud.google.com/bigquery/docs/managing-tables Feb 3, 2025 ... ... (developer): Set table_ids to the list of the IDs of the original tables. ... To delete all of the tables in the dataset, delete the dataset. When ...
Batching INSERT statements
https://groups.google.com/g/sqlalchemy/c/GyAZTThJi2I Oct 9, 2017 ... Oracle, SQL Server and others don't support INSERT..VALUES with ... If the migration is LARGE, i'll drop all the indexes the tables too, and ...
Error on upgrade of h2 from 1.4.200 to 2.0.204
https://groups.google.com/g/ebean/c/_sdyThBB1QI Dec 27, 2021 ... ... all create/drop statements and queries? Would that be compatible with most or all SQL versions? ... all table names and all column names are ...
Use row-level security | BigQuery | Google Cloud
https://cloud.google.com/bigquery/docs/managing-row-level-security DROP ROW ACCESS POLICY my_row_filter ON project.dataset.my_table;. Delete all the row-level access policies from a table:.
Performance: DROP TABLE very slow on large tables
https://groups.google.com/g/h2-database/c/rVW-slB7KRY Then the db was ok again (i.e. responsive). While I was waiting all those hours I was browsing this forum and also looking for an alternative database product.
Implement restore points (vaguely similar to Oracle)
https://groups.google.com/g/h2-database/c/iJLjES5j2TU Although it's more than drop all schemas, because it would require a wiped database. ... drop connections on a `restore to point` SQL execution. If no ...
Continuous Increase in H2 db size after dropping and loading same ...
https://groups.google.com/g/h2-database/c/i2fVBYBF3as Jul 8, 2013 ... From about 200mb, it increased to about 2Gb. This happens even when I drop all tables and load a fresh set of data (which is almost of the same ...
Manage datasets | BigQuery | Google Cloud
https://cloud.google.com/bigquery/docs/managing-datasets The dataset copy job overwrites all of the data in the destination dataset, including both the tables and schema. The destination table might not reflect ...
Unix scripts to extract DDL from imp show=y
https://groups.google.com/g/comp.databases.oracle.server/c/JXJBFSw3gvs May 22, 2001 ... # ugly_DDL.ksh textfile > bunch_of_SQL.sql. # Note: to remove ... > >Right, but INDEXFILE contains only CREATE TABLE/INDEX. I need all the
Query multiple tables using a wildcard table | BigQuery | Google Cloud
https://cloud.google.com/bigquery/docs/querying-wildcard-tables Wildcard tables enable you to query multiple tables using concise SQL statements. Wildcard tables are available only in GoogleSQL.
Data manipulation language (DML) statements in GoogleSQL ...
https://cloud.google.com/bigquery/docs/reference/standard-sql/dml-syntax DELETE [FROM] target_name [alias] WHERE condition. To delete all rows in a table, use the TRUNCATE TABLE statement. To delete all rows in a partition without ...
cbt CLI reference | Bigtable Documentation | Google Cloud
https://cloud.google.com/bigtable/docs/cbt-reference ... table deleteallrows Delete all rows deleteappprofile Delete app profile for an instance deletecluster Delete a ... Java is a registered trademark of Oracle ...
Unlogged Deletes in Oracle
https://groups.google.com/g/comp.databases.oracle.server/c/niGt3xHkeDA deletes, as a regular piece of DML, always generates redo. That said, you could, of course, drop all those unnecessary indexes ... DROP TABLE old_table;.
Re: Considering jOOQ
https://groups.google.com/g/jooq-user/c/K_tTB4-prDQ I don't know about Oracle, but Postgre's objects all inherit from PGobject ... query planner has gotten smarter about using table conditionals to make that select ...
Query syntax | BigQuery | Google Cloud
https://cloud.google.com/bigquery/docs/reference/standard-sql/query-syntax That is, a query can reference a table multiple times at the same timestamp ... Drop all unmatched columns in both inputs. FULL [OUTER] BY NAME or. FULL ...
Java junit tests fails with "object already exists" after upgrade from ...
https://groups.google.com/g/h2-database/c/NGb1H_T0BMo Oct 24, 2023 ... The drop-tables.sql script contains. DROP ALL OBJECTS. The h2server is ... value="jdbc:h2:mem:name;MODE=Oracle;DB_CLOSE_DELAY=-1 ...
Deletes | Bigtable Documentation | Google Cloud
https://cloud.google.com/bigtable/docs/delete-data 4 days ago ... Note: You can delete all rows in the table without specifying the row key prefix when you use the ...