In  on the use of the SQL standard INFORMATION_SCHEMA views, on the columns about schema names, the following warning is repeated each time:  ** Important ** Do not use INFORMATION_SCHEMA views to determine the schema of an object. INFORMATION_SCHEMA views only represent a subset of the metadata of an object. The only reliable way to find the schema of a object is to query the sys.objects catalog view.  A casual perusal of this view on my database shows that all of the schemas appear to be reported as expected, so I'm wondering what exactly the problem is we're being warned about here.  Under what circumstances can INFORMATION_SCHEMA prove unreliable in this regard?
122006
According to MS-DOCS about , the schema  have a warning note that says:     ** Important ** Do not use INFORMATION_SCHEMA views to determine the schema of an object. The only reliable way to find the schema of a   object is to query the sys.objects catalog view.   Why can't INFORMATION_SCHEMA views be used to determine the schema of an object?  Is this information erroneous?
74052
I have lots of schemas and tables. I want to generate create script of all of my tables. I am using below statement and it is working pretty well.  SELECT DBMS_METADATA.GET_DDL('TABLE','table_name','schema') FROM DUAL   But this statement also generates all primary and foreign key scripts that belong to table. So, is there any way to not include primary and foreign keys in create table scripts
91878
I imported a bunch of tables from SQL Server 2000 to my 2008 database. All the imported tables are prefixed with my username eg: erpadmin.tablename.  In the table properties it lists 'erpadmin' as the db schema. When I write a query I now have to include 'erpadmin.' in front of all the table names which is confusing.  Current result:  select * from erpadmin.tablename   Desired result:  select * from  tablename
18924
I've just spent several hours trying to fix a deployment that was failing with the following extremely helpful error message:  Error: objects/Opportunity.object(2098,13):duplicate value found: &lt;unknown&gt; duplicates value on record with id: &lt;unknown&gt;   After a lot of Googling (which didn't help) and even more trial and error (which finally did), I've discovered that the question I really needed an answer to is...     If Salesforce gives me a "duplicate value found: &lt;unknown&gt; duplicates value found on record with id &lt;unknown&gt;", how can I figure out what's actually gone wrong?   There are several possible answers online, and a couple here on StackExchange, but without knowing how to narrow the focus after getting such a horrible, useless error message, it's too easy to fall for red herrings.
108265
I need to set up some views that will pull some data from a custom table I created.  Some views will need to pull content the regular way and from my custom table (where I may query for a particular nid, etc.).  How do I do this, or where is a good place to research?
24956
I wonder if there is the ability to print / export the schema builder?  If so, where can I find? If not, would be a great idea to implement this feature for future releases.
84162
I'm familiar with the issue behind ORA-01775: looping chain of synonyms, but is there any trick to debugging it, or do I just have to "create or replace" my way out of it?    Is there a way to query the schema or whatever to find out what the current definition of a public synonym is?    Even more awesome would be a graphical tool, but at this point, anything would be helpful.
2165
What is a  free tool to compare two Sql Server tables (data and schema).   It would be great if the tool can script the differences found.  I also went through some older . The closest I have seen is  but I would love to try more options.
20978
What is the difference between Views and Materialized Views in Oracle?
98231
The "N+1 selects problem" is generally stated as a problem in Object-Relational mapping (ORM) discussions, and I understand that it has something to do with having to make a lot of database queries for something that seems simple in the object world.  Does anybody have a more detailed explanation of the problem?
39271
I have a table that has a very high usage (insert/update/select) - one of the operations is to obtain a count of the number of rows. So far I've been using the classic select count(pk) from table but I'm thinking to read it from information_schema instead of doing the count.  select table_rows from tables where table_name = 'my_table'  Is this reliable enough ?  If there is a different method please let me know.  thanks!
19579
I've inherited a site where I noticed that    there is an excessive use of Schema.org in all navigation elements pages describing products are marked as itemtype="http://schema.org/CreativeWork"   So I'm wondering if these tags are sending the wrong message and not truly optimized. I realize that the nav (1) is done in some themes, but I'm more worried about (2). Can it be a hit SEO-wise to mislabel pages instead of products?
113045
I've been  about entity field queries.  What are the advantages of using entity field queries (EFQ) over views?  What are the largest pain points/disadvantages of using EFQ ?
15483
I'm experiencing an annoying problem with a table named SysMessages in one of our databases. When I run a select statement I don't get the contents of this table, but of the sys.sysmessages view in the master database. A use [DBNAME] doesn't help, nor select * from [DBNAME].dbo.SysMessages.  I'm in the middle of a migration to a newer SQL Server version. In SQL Server 2008 R2 I didn't encounter this problem with this database, but in SQL Server 2016 I'm not able to query my own SysMessages table.  Any help would be greatly appreciated.
42684
I know there is a question  but I checked its answers and it didn't help. I'm just learning developing modules for Drupal so maybe it's something really stupid but I have no idea...  My hook (in testModule4.install):  function testModule4_update_7001() {  $schema['testModule4_table'] = array(     'description' =&gt; 'TODO: Description',     'fields' =&gt; array(         'main_id' =&gt; array(             'description' =&gt; 'TODO: Description.',             'type' =&gt; 'serial',             'not null' =&gt; TRUE,         ),         'settings' =&gt; array(             'description' =&gt; 'TODO: Description',             'type' =&gt; 'text',             'not null' =&gt; FALSE,         ),         'uid' =&gt; array(             'description' =&gt; 'TODO: Description',             'type' =&gt; 'int',             'not null' =&gt; FALSE,         ),         'created' =&gt; array(             'description' =&gt; 'TODO: Description',             'type' =&gt; 'int',             'not null' =&gt; FALSE,         ),         'changed' =&gt; array(             'description' =&gt; 'TODO: Description',             'type' =&gt; 'int',             'not null' =&gt; FALSE,         ),     ),     'primary key' =&gt; array('main_id'), );  db_create_table('testModule4_table', $schema['testModule4_table']);  }   My module is working just fine. The schema_version of module in database is 0 but update.php just cannot see it. What can be the cause of that? :/ I was trying clearing cache and reenabling a module but without success. I just don't know where to search for source of the problem. If you need more data, just comment :/ .  Edit:  I created simple module:  testModule.module:  &lt;?php   function testModule_myform($delta = "") {      $form['something'] = array(         '#type' =&gt; 'markup',         '#markup' =&gt; 'Something',     );     return $form; }    /**  * Implements hook_menu();  */  function testModule_menu() {     $items["test/test"] = array(         'title' =&gt; 'testModule',         'description' =&gt; 'TODO: Description',         'page callback' =&gt; 'drupal_get_form',         'page arguments' =&gt; array('testModule_myform'),         'access callback' =&gt; TRUE,      );     return $items; }   testModule.info:  name = testModule description = Test module for Drupal experiments. package = CustomTest core = 7.x   testModule.install:  function testModule_update_7001() {     drupal_set_message('It works!');     print 'Show something!'; }   And it still ignores this hook... Is it officially a Drupal bug and I need to reinstall the whole Drupal? >_&lt;
105544
Could you please give the command to add a column to all the tables if the table doesn't contain that column in a schema?  e.g. The schema schema1 contains 50 tables in which 20 tables contain a column named colTest.   I need to add the column colTest to the remaining 30 tables.
21180
I want to install scott schema, a sample database in oracle.  But in express edition, I can't find out it.  Please help me install it on Oracle 11g express.  I'm a newbie, pls help me