What SQL can be used to list the tables, and the rows within those tables in an SQLite database file - once I have attached it with the `ATTACH` command on the SQLite&amp;nbsp;3 command line tool?



How can I list the tables in a SQLite database file that was opened with ATTACH?

I&#39;m running a project on a Postgres database and need to retrieve the comments on columns within the DB to be used as table headings and such. I have seen that there are a couple of built in functions ([pg_description](http://www.postgresql.org/docs/9.1/static/catalog-pg-description.html) and [col_description](http://www.postgresql.org/docs/9.1/static/functions-info.html)) but i haven&#39;t been able to find examples on how to use them and playing around with them has proved pretty futile.

So I was wondering if any has been able to do this before and if so, how?

Retrieving Comments from a PostgreSQL DB

I need an sql query to enumerate all views (I only need the view names) of a specific database in SQL Server 2005. Thanks in advance!

Sql Query to list all views in an SQL Server 2005 database

I would like to extract the GPS EXIF tag from pictures using php.
I&#39;m using the `exif_read_data()` that returns a array of all tags + data :

    GPS.GPSLatitudeRef: N
    GPS.GPSLatitude:Array ( [0] =&gt; 46/1 [1] =&gt; 5403/100 [2] =&gt; 0/1 ) 
    GPS.GPSLongitudeRef: E
    GPS.GPSLongitude:Array ( [0] =&gt; 7/1 [1] =&gt; 880/100 [2] =&gt; 0/1 ) 
    GPS.GPSAltitudeRef: 
    GPS.GPSAltitude: 634/1

I don&#39;t know how to interpret 46/1 5403/100 and 0/1 ? 46 might be 46&#176; but what about the rest especially 0/1 ?

    angle/1 5403/100 0/1


What is this structure about ? 

How to convert them to &quot;standard&quot; ones (like 46&#176;56′48″N 7&#176;26′39″E from wikipedia) ? I would like to pass thoses coordinates to the google maps api to display the pictures positions on a map !

PHP extract GPS EXIF data

I can get a list of unique constraints fairly easily with the following query:

    select * from INFORMATION_SCHEMA.TABLE_CONSTRAINTS where CONSTRAINT_TYPE=&#39;UNIQUE&#39;

But how do I get a list of the columns that each unique constraint applies to?

Get the unique constraint columns list (in TSQL)?

I want to associate custom metadata with a `git commit`.  Specifically to record a review ID from a code review but it could be anything.  Tags seem a natural way to do that but I expect to have a review for every commit and I don&#39;t want to clutter `gitk` with tons of tags.  Is there some other mechanism to add custom metadata?  Can I make certain tags invisible?  If I could tell `gitk` not to display tags matching some pattern or RE, that would likely work but I don&#39;t see a way to do that.

Can I add metadata to git commits? Or can I hide some tags in gitk

In SQL Server there is two schemas for metadata: 

- INFORMATION_SCHEMA 
- SYS 

I have heard that `INFORMATION_SCHEMA` tables are based on ANSI standard. When developing e.g. stored procedures, should it be wise to use `INFORMATION_SCHEMA` tables over `sys` tables?

SQL Server: should I use information_schema tables over sys tables?

I keep getting this problem everytime i try to migrate using the commandline: `php bin/console make:migration`
or even `doctrine:migration status`
when i try the `doctrine:migration:sync-metadata-storage` as they tell me I still get the same error message.

I&#39;m currently learning symfony and have been following a guide but I get this problem somehow
Symfony 4.4
php 7.2

Symfony Make:Migration : The metadata storage is not up to date, please run the sync-metadata-storage command to fix this issue

I&#39;m trying to find a query which will return me a list of the foreign keys for a table and the tables and columns they reference.  I am half way there with 

    SELECT a.table_name, 
           a.column_name, 
           a.constraint_name, 
           c.owner
    FROM ALL_CONS_COLUMNS A, ALL_CONSTRAINTS C  
    where A.CONSTRAINT_NAME = C.CONSTRAINT_NAME 
      and a.table_name=:TableName 
      and C.CONSTRAINT_TYPE = &#39;R&#39;

But I still need to know which table and primary key are referenced by this key.  How would I get that?

List of foreign keys and the tables they reference in Oracle DB

I am trying to set up in-app purchases but I don&#39;t know how to get rid of the &quot;Missing Metadata&quot; shown below.

The only yellow dot I see from the page is the &quot;Localizations&quot; section, but I completed the &quot;Display Name&quot; and &quot;Description&quot;.

I don&#39;t know what else I can do or what I am doing wrong.

![Missing Metadata (yellow dot)][1]

---

![Missing Metadata (yellow dot)][2]


  [1]: https://i.stack.imgur.com/XW1Dl.png
  [2]: https://i.stack.imgur.com/NydPH.png

In-App Purchases stuck in &quot;Missing Metadata&quot; state

Is there a maintained package I can use to retrieve and set MP3 ID3 metadata using Python?


Accessing MP3 metadata with Python

Two common &lt;code&gt;meta&lt;/code&gt; element attributes are: 

    &lt;meta name=&quot;&quot; content=&quot;&quot;&gt;

and

    &lt;meta property=&quot;&quot; content=&quot;&quot;&gt;

what is the difference between meta name and meta property?



What&#39;s the difference between meta name and meta property?

I want to create a list of columns in SQL Server 2005 that have identity columns and their corresponding table in T-SQL.

Results would be something like:

TableName, ColumnName

How do you determine what SQL Tables have an identity column programmatically

Is there a way to colorize parts of logs in the eclipse console.  I know I could send to error and standard streams and color them differently but I&#39;m more looking someting in the lines of ANSI escape codes (or anyother, HTML ?) where I could embed the colors in the string to have it colored in the logs.

It sure would help making the important bits stand out without resorting to weird layout, rather keep the layout to the log4j setups 

here is an example of what I am looking for :

[INFO ] The grid is complete ....... **false**

where the bold parts would be in blue, this coloring can be controlled by the application to an extent.  like so (tags are conceptual and arbitrary, but you get the idea):

log.info(String.format(&quot;The grid is complete ....... `&lt;blue&gt;`%s`&lt;/blue&gt;`&quot;, isComplete ));

---
On a more general note it is the ability to embed meta information in the logs to help the presentation of these logs.  Much like we tag web pages content to help the presentation of the information by CSS.



Colorize logs in eclipse console

I know there is another question with exact the same problem, but I went trough all those answers, and none helped me. :( ([This was the question.][1])

I just created a new ASP.NET MVC project and joined a few &#39;.dll&#39;s in the solution. Now when I try to build the project I get the error message shown below on 3 of the 5 libraries.

    Error	CS0006	Metadata file &#39;C:\Users\...\source\Database\bin\Debug\DataAccessLayer.dll&#39; could not be found	Logic	C:\Users\...\source\Logic\CSC	1	Active

    Error	CS0006	Metadata file &#39;C:\Users\...\source\Logic\bin\Debug\Logic.dll&#39; could not be found	PTS2-MVC	C:\Users\...\source\PTS2-MVC\CSC	1	Active

    Error	CS0006	Metadata file &#39;C:\Users\...\source\PTS2-MVC\bin\PTS2-MVC.dll&#39; could not be found	PTS2-MVC.Tests	C:\Users\...\source\PTS2-MVC.Tests\CSC	1	Active


When I go to the bin\debug folder of that .dll, I see that it is empty, and the other .dll where I do not get an error message, is not empty. But I am clueless how to fix this or what I did to make this happen.

The most common answer is to go to the **properties** of the **solution** and go to **configuration** and *uncheck* -&gt; *apply* -&gt; *check* and *apply* again, but that didn&#39;t work


  [1]: https://stackoverflow.com/questions/1421862/metadata-file-dll-could-not-be-found

VS 2017 Metadata file &#39;.dll could not be found

I want to read the metadata in media files and then save that metadata in a text/xml file, so that I can later insert that data in my database. I would prefer to use ffmpeg.

Also is the same thing possible with MediaInfo?? I know I can get the metadata for individual tracks using MediaInfo, but I would want to automate it; as in whenever a new media file is found, read its metadata and then store it in a txt/xml file.

Or, is there any other tool/utility/API that I can use for this?

Retrieving and Saving media metadata using FFmpeg

I&#39;m looking for an efficient way to get the list of unique commit authors for an SVN repository as a whole, or for a given resource path. I haven&#39;t been able to find an SVN command specifically for this (and don&#39;t expect one) but I&#39;m hoping there may be a better way that what I&#39;ve tried so far in Terminal (on OS X):

    svn log --quiet | grep &quot;^r&quot; | awk &#39;{print $3}&#39;
    
    svn log --quiet --xml | grep author | sed -E &quot;s:&lt;/?author&gt;::g&quot;

Either of these will give me one author name per line, but they both require filtering out a fair amount of extra information. They also don&#39;t handle duplicates of the same author name, so for lots of commits by few authors, there&#39;s tons of redundancy flowing over the wire. More often than not I just want to see the unique author usernames. (It actually *might* be handy to infer the commit count for each author on occasion, but even in these cases it would be better if the aggregated data were sent across instead.) 

I&#39;m generally working with client-only access, so `svnadmin` commands are less useful, but if necessary, I might be able to ask a special favor of the repository admin if strictly necessary or much more efficient. The repositories I&#39;m working with have tens of thousands of commits and many active users, and I don&#39;t want to inconvenience anyone.

How to get a list of all Subversion commit author usernames?

I&#39;m learning how to use Greasemonkey, and was wondering what the `@namespace` metadata id is  for.  

Does it have to be a web address? Or can it be a folder/directory on my computer?  

Does it even need to be filled in?


What is the Greasemonkey namespace needed for?

I am looking for T-SQL code to list all tables in all databases in SQL Server (at least in SS2005 and SS2008; would be nice to also apply to SS2000). The catch, however, is that I would like a ***single result set***. This precludes the otherwise excellent answer from [Pinal Dave][1]:

    sp_msforeachdb &#39;select &quot;?&quot; AS db, * from [?].sys.tables&#39;

The above stored proc generates one result set ***per database***, which is fine if you are in an IDE like SSMS that can display multiple result sets. However, I want a single result set because I want a query that is essentially a &quot;find&quot; tool: if I add a clause like `WHERE tablename like &#39;%accounts&#39;` then it would tell me where to find my BillAccounts, ClientAccounts, and VendorAccounts tables regardless of which database they reside in.

---

2010.05.20 Update, about 20 minutes later...
-----

So far, Remus&#39; answer looks most interesting. Rather than post this as an answer and award it to myself, I am posting a version of it here that I have modified to include the DB name and a sample filter clause. It is looking like Remus will get the credit for the answer, though, at this point!

    declare @sql nvarchar(max);
    set @sql = N&#39;select b.name as &quot;DB&quot;, a.name collate Latin1_General_CI_AI as &quot;Table&quot;, object_id, schema_id, cast(1 as int) as database_id  from master.sys.tables a join sys.databases b on database_id=1 where a.name like &#39;&#39;account%&#39;&#39;&#39;;
    
    select @sql = @sql + N&#39; union all select b.name as &quot;DB&quot;, a.name collate Latin1_General_CI_AI, object_id, schema_id, &#39; + cast(database_id as nvarchar(10)) + N&#39; from &#39; + quotename(name) + N&#39;.sys.tables a join sys.databases b on database_id=&#39; + cast(database_id as nvarchar(10)) + &#39;where a.name like &#39;&#39;account%&#39;&#39;&#39;
    from sys.databases where database_id &gt; 1 
    
    and state = 0
    and user_access = 0;
    
    exec sp_executesql @sql;

---

2010.05.24 Update -- New Front runner!
-----
The feedback and answers have been great. Continued collaborative participation has led to a **new frontrunner**: KM&#39;s answer from May 21! 

Here are the issues I uncovered with Remus&#39; solution:

**Major issue:** Users have different permissions which leads the query to succeed based on the data (i.e. the filtering value). Run on my production database with ***no*** filtering (i.e. omitting the `WHERE` clause) I received this error on several DBs that I do not have permission to access:

&gt; The server principal &quot;msorens&quot; is not able to access the database
&gt; &quot;ETLprocDB&quot; under the current security context.

The query ***will*** succeed with some filtering clauses--those that do not touch the DBs outside my access level.

**Minor issue:** Not easily degradable to SQL Server 2000 support (yes, there are still some of us out there using it...) because it builds a single string while accumulating entries for each database. With my system, I surpassed the 8000-character mark at around 40 databases.

**Minor issue:** Duplicate code--the loop setup essentially duplicates the loop body. I understand the rationale but it is just a pet peeve of mine...

KM&#39;s answer is not afflicted by these issues. The stored proc `sp_msforeachdb` takes into account the user&#39;s permissions so it avoids permission problems. I have not yet tried the code with SS2000 but KM indicates the adjustments that should do it. 

I am posting next my modifications to KM&#39;s answer based on my personal preferences. Specifically:

* I have removed the server name as it does not really add anything in the result set. 
* I have split the name components into their own fields in the result set (db name, schema name, and table name).
* I have introduced separate filters for each of the three fields.
* I have added sorting by the three fields (which can be modified to your preferences).

Here is my modification to KM&#39;s code (with a sample filter applied just to the table name):


    SET NOCOUNT ON
    DECLARE @AllTables table (DbName sysname,SchemaName sysname, TableName sysname)
    DECLARE
         @SearchDb nvarchar(200)
    	,@SearchSchema nvarchar(200)
    	,@SearchTable nvarchar(200)
        ,@SQL nvarchar(4000)
    SET @SearchDb=&#39;%&#39;
    SET @SearchSchema=&#39;%&#39;
    SET @SearchTable=&#39;%Account%&#39;
    SET @SQL=&#39;select &#39;&#39;?&#39;&#39; as DbName, s.name as SchemaName, t.name as TableName from [?].sys.tables t inner join [?].sys.schemas s on t.schema_id=s.schema_id WHERE &#39;&#39;?&#39;&#39; LIKE &#39;&#39;&#39;+@SearchDb+&#39;&#39;&#39; AND s.name LIKE &#39;&#39;&#39;+@SearchSchema+&#39;&#39;&#39; AND t.name LIKE &#39;&#39;&#39;+@SearchTable+&#39;&#39;&#39;&#39;
    
    INSERT INTO @AllTables (DbName, SchemaName, TableName)
        EXEC sp_msforeachdb @SQL
    SET NOCOUNT OFF
    SELECT * FROM @AllTables ORDER BY DbName, SchemaName, TableName


  [1]: http://blog.sqlauthority.com/2009/04/26/sql-server-list-all-the-tables-for-all-databases-using-system-tables/


How do I list all tables in all databases in SQL Server in a single result set?

I am trying to find a way to extract information about my tables in SQL Server (2008).  
The data I need needs to include the **description of the table** (filled from the Description property in the Properties Window), a **list of fields** of that table and their respective **data types**.

Is there any way I can extract such meta-data?  I presume I have to use some `sys` sp but I&#39;n not sure which one. 

SQL Server: Extract Table Meta-Data (description, fields and their data types)

I&#39;m working on an [open source project][1] dealing with adding metadata to folders. The provided (Python) API lets you browse and access metadata like it was just another folder. Because it is just another folder.

    \folder\.meta\folder\somedata.json

Then I came across [HDF5][2] and its derivation [Alembic][3].

Reading up on HDF5 in the book [Python and HDF5][4] I was looking for benefits to using it compared to using files in folders, but most of what I came across spoke about the benefits of a hierarchical file-format in terms of its simplicity in adding data via its API:

    &gt;&gt;&gt; import h5py
    &gt;&gt;&gt; f = h5py.File(&quot;weather.hdf5&quot;)
    &gt;&gt;&gt; f[&quot;/15/temperature&quot;] = 21

Or its ability to read only certain parts of it upon request (e.g. random access), and parallel execution of a single HDF5 file (e.g. for multiprocessing)

You could mount HDF5 files, [https://github.com/zjttoefs/hdfuse5][5]

It even boasts a strong yet simple foundation concept of **Groups** and **Datasets** which from wiki reads:

 - Datasets, which are multidimensional arrays of a homogeneous type 
 - Groups, which are container structures which can hold datasets and
   other groups

Replace **Dataset** with **File** and **Group** with **Folder** and the whole feature-set sounds to me like what files in folders are already fully capable of doing.

For every benefit I came across, not one stood out as being exclusive to HDF5.

So my question is, if I were to give you one HDF5 file and one folder with files, both with identical content, in which scenario would HDF5 be better suited?

Edit:

Having gotten some responses about the portability of HDF5.

It sounds lovely and all, but I still haven&#39;t been given an example, a scenario, in which an HDF5 would out-do a folder with files. Why would someone consider using HDF5 when a folder is readable on any computer, any file-system, over a network, supports &quot;parallel I/O&quot;, is readable by humans without an HDF5 interpreter.

I would go as far as to say, a folder with files is far more portable than any HDF5.

Edit 2:

Thucydides411 just gave an example of a scenario where portability matters.
https://stackoverflow.com/a/28512028/478949

I think what I&#39;m taking away from the answers in this thread is that HDF5 is well suited for when you need the organisational structure of files and folders, like in the example scenario above, with lots (millions) small (~1 byte) data structures; like individual numbers or strings. That it makes up for what file-systems lack by providing a &quot;sub file-system&quot; favouring the small and many as opposed to few and large.

In computer graphics, we use it to store geometric models and arbitrary data about individual vertices which seems to align quite well with it&#39;s use in the scientific community.

  [1]: https://github.com/abstractfactory/openmetadata
  [2]: http://www.hdfgroup.org/HDF5/
  [3]: http://www.alembic.io/
  [4]: http://shop.oreilly.com/product/0636920030249.do
  [5]: https://github.com/zjttoefs/hdfuse5

How is HDF5 different from a folder with files?

I am new to android and I have not seen or heard about meta data before. However I google it and search about it on YouTube that it is basically a information of your object. Correct me if I am wrong. Can any one help me to understand it in a better way.

1) What is meta data?

2) Why is it used in Android? 

It will be good if explanation is given with example of why metadata is used in Android. I have seen them inside manifest&#39;s activity metadata tag.   

What is metadata ? And what is the use of it in android

I&#39;ve got a JPEG image which was taken on an iphone. On my desktop PC (Windows Photo Viewer, Google Chrome, etc) the orientation is incorrect.

I&#39;m working on an ASP.NET MVC 3 web application where i need to upload photos (currently using plupload).

I&#39;ve got some server-side code to process images, including reading EXIF data.

I&#39;ve tried reading the `PropertyTagOrientation` field in the EXIF meta data (using GDI - `Image.PropertyItems`), but the field isn&#39;t present.

So it&#39;s either some specific iphone meta data, or some other meta data.

I&#39;ve used another tool like Aurigma Photo Uploader, and it reads the meta data correctly and rotates the image. How does it do this?

Does anyone know what other JPEG meta data could contain the information required in order to know that it needs to be rotated, that is used by Aurigma?

Here&#39;s the code i&#39;m using to read the EXIF data:

    var image = Image.FromStream(fileStream);
    
    foreach (var prop in image.PropertyItems)
    {
       if (prop.Id == 112 || prop.Id == 5029)
       {
          // do my rotate code - e.g &quot;RotateFlip&quot;
          // Never get&#39;s in here - can&#39;t find these properties.
       }
    }

Any ideas?



Problem reading JPEG Metadata (Orientation)

Is it possible to select from `show tables` in MySQL?

    SELECT * FROM (SHOW TABLES) AS `my_tables`

Something along these lines, though the above does not work (on 5.0.51a, at least).

Select data from &quot;show tables&quot; MySQL query

## Background
When dropping (or replacing) objects in PostgreSQL, if there are dependencies, the drop will fail (without specifying `CASCADE`).

## Problem
The error message returned by the database does not list the dependent objects.

## Example Solution
The query might look something like:

    SELECT * FROM information_schema i, pg_depend pd WHERE
      i.object_id = pd.object_id AND
      i.object_type = &#39;TABLE&#39; AND
      i.object_schema = &#39;public&#39; AND
      i.object_name = &#39;table_with_dependents&#39;;

The `objid` is missing.

## Related
- http://postgresql.1045698.n5.nabble.com/information-schema-problem-td2144069.html
- http://www.alberton.info/postgresql_meta_info.html


## Question
How do you generate a list of dependent objects by name and type?

Find dependent objects for a table or view

Is there a standard or convention for embedding metadata in a Markdown formatted post, such as the publication date or post author for conditional rendering by the renderer?

Looks like this [Yaml metadata](https://github.com/blog/1647-viewing-yaml-metadata-in-your-documents) format might be it.

There are all kinds of strategies, e.g. an accompanying file `mypost.meta.edn`, but I&#39;m hoping to keep it all in one file.

All Metadata Solutions on Gang of Coders

Total of 26 Metadata Solutions