<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Reinier Olislagers wrote / napísal(a):
<blockquote cite="mid:4F90104D.8030605@gmail.com" type="cite">
<pre wrap="">On 19-4-2012 15:02, Ludo Brands wrote:
</pre>
<blockquote type="cite">
<pre wrap="">
</pre>
<blockquote type="cite">
<pre wrap="">Ludo here I do not understand what do you want to say. may be, that my
</pre>
</blockquote>
<pre wrap="">english is not so good ;-)
</pre>
<blockquote type="cite">
<pre wrap="">Can you explain please what is your proposal regarding to stIndexes ?
</pre>
</blockquote>
<pre wrap="">stIndexes is currently not implemented: keep it that way (or drop it) but
add and implement stTableConstraints, stReferentialConstraints,
stKeyColumnUsage,
stConstraintColumnUsage and stConstraintTableUsage. And why not some other
missing information_schema views like 'views' or 'schemata'.
Delphi compatibility? Delphi adodb defines and implements the following:
type TSchemaInfo = (siAsserts, siCatalogs, siCharacterSets, siCollations,
siColumns, siCheckConstraints, siConstraintColumnUsage,
siConstraintTableUsage, siKeyColumnUsage, siReferentialConstraints,
siTableConstraints, siColumnsDomainUsage, siIndexes, siColumnPrivileges,
siTablePrivileges, siUsagePrivileges, siProcedures, siSchemata,
siSQLLanguages, siStatistics, siTables, siTranslations, siProviderTypes,
siViews, siViewColumnUsage, siViewTableUsage, siProcedureParameters,
siForeignKeys, siPrimaryKeys, siProcedureColumns);
</pre>
</blockquote>
<pre wrap=""><!---->Fine with Ludo's proposal; dropping stIndexes... and adding new ISO
compliant stuff if needed.
Delphi has at least adodb and dbexpress with various implementations....
so not much of a standard.
Keeping to the information_schema standard seems like a good idea -
especially because it will make it easier to easily get useful info from
an ISO SQL 92+ compliant database..
Anybody against this? Michael? Joost?
</pre>
</blockquote>
Not against ;-)<br>
Small drawback will be, that for those DB that do not have
INFORMATION_SCHEMA there will be need for adding many selects against
system tables (or do not implement them at all ;-))<br>
<br>
<blockquote cite="mid:4F90104D.8030605@gmail.com" type="cite">
<pre wrap="">Has anybody used this functionality in sqldb at all?
</pre>
</blockquote>
No. And I do not expect that I will use it in future.<br>
<br>
-Laco.<br>
<br>
</body>
</html>