Question : A schema was created with the name of a windows user [DOMAINFoo]. I receive this error message when […]
Tag: ddl
ERWIN create and use database
Question : I’m trying to generate physical database from my logical model using ERWIN 7. All is well in the […]
How to determine the collation of a table in PostgreSQL?
Question : I want to script a check of the collations used on my tables in PostgreSQL, but googling for […]
SQL Server 2012: Give rights to read ddl but not modify?
Question : What rights would I need to be give a user for them to be able to view all […]
lock-ddl-per-table option not working as expected in Xtrabackup
Question : I’ve recently been getting the following errors on some of my Percona XtraBackup backups: InnoDB: An optimized (without […]
creating a new table results in incorrect syntax error [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. Want to improve this question? Update the […]
What’s wrong with my DDL statement? [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. Too localized – this could be because […]
Prevent DROP COLUMN in PostgreSQL
Question : Can I stop DROP COLUMN from succeeding on particular tables in PostgreSQL 9 or 10 or later? My […]
how to create a synonym in Oracle? [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. Too localized – this could be because […]
Does issuing DDL against a view in PostgreSQL take out the same locks as issuing DDL against a table?
Question : I understand that views are implemented using the rule system but I’m unclear if this has any advantages/disadvantages […]