The standards tag has no wiki summary.
0
votes
2answers
72 views
Naming foreign key columns
Now I hear that the best practice for naming foreign key columns is the name of the table and field (and maybe the function if there are multiple foreign keys to the same table), for example, a ...
8
votes
2answers
169 views
Where can I find the SQL standard document?
Where can I find a legal copy of the ISO SQL 2008 standard?
5
votes
1answer
132 views
Are view references in a query properly called “derived tables” as such?
While answering a question on stackoverflow, I presented a definition of derived tables:
A derived table is a complete query, inside of parentheses, that is used as if it were a real table.
But ...
2
votes
3answers
81 views
Looking for industry standard and/or tool to represent and export RDBMS metadata
Do you know of an industry standard that is designed to describe the metadata contents of a relational database (or part of it, such as tables, columns, etc.)?
Do you know if a tool exists that does ...
2
votes
1answer
82 views
SQL ISO Standard for group concatenation
Is there an operator in the latest standard SQL:2011 (or earlier) that will handle group concatenation the likes of which we currently have to resort to these tricks for?
GROUP_CONCAT in MySQL
FOR ...
2
votes
4answers
439 views
Should I use a Column naming convention or rely on column descriptions?
Frankly I am stunned that after some basic (very basic) internet searches I have not been able to find a comprehensive naming convention or guideline or SQL object and column naming.
The parallel ...
3
votes
1answer
873 views
ERD via Chen's notation: How do I organize multiple 'last done' entries?
I'm having an issue creating a little practice ERD. I'm trying to do some more difficult stuff, and I'm not sure what the standard way to organize it is.
Basically, I don't know which of these is ...
5
votes
2answers
802 views
Single data type for imprecise date values, as allowed by ISO 8601
How can I store date and time values with reduced precision in a PostgreSQL type, and have them behave as date and/or time values?
ISO 8601 allows date values with reduced precision. ‘1964’, ...
3
votes
4answers
166 views
Which SQL standard is most broadly and completely supported?
I want to concentrate on one of the SQL language specs for learning and reference purposes. Which version of the SQL standard is most broadly supported across DBMS'es so that I can focus my time and ...
18
votes
5answers
5k views
SQL: SELECT All columns except some
Is there a way to SELECT all columns in a table, except specific ones? IT would be very convenient for selecting all the non-blob or non-geometric columns from a table.
Something like:
SELECT * ...
3
votes
4answers
963 views
How different are the top DB vendor's SQL (DML-) dialects from each other?
Does someone who has worked extensibly SQL-wise with at least two top DB products (such as Oracle, SQL Server, Informix, Sybase, DB2, Teradata) know how different the DB vendor's SQL dialects are from ...
3
votes
3answers
132 views
Obtaining gratis copy of the SQL specification?
There used to be a public link to the JTC 1/SC 32 working drafts of 9075:2003, but the link I had has not worked since they started on the post-2003 revisions. Given that there are publicly available ...
