dabo Commit
Revision 7012
Date: 2011-12-09 00:32:32 -0800 (Fri, 09 Dec 2011)
Author: Jacekk
Trac: http://trac.dabodev.com/changeset/7012
Changed:
U trunk/dabo/db/dbMsSQL.py
Log:
The views added to list retrieved from information schema table.
Diff:
Modified: trunk/dabo/db/dbMsSQL.py
===================================================================
--- trunk/dabo/db/dbMsSQL.py 2011-12-08 17:12:44 UTC (rev 7011)
+++ trunk/dabo/db/dbMsSQL.py 2011-12-09 08:32:32 UTC (rev 7012)
@@ -92,11 +92,11 @@
dbName = self.database
sql = """
-select table_name
+select table_schema + '.' + table_name AS table_name
from INFORMATION_SCHEMA.TABLES
where table_catalog = '%(db)s'
- and table_type = 'BASE TABLE'
- order by table_name """
+ and table_type IN ('BASE TABLE', 'VIEW')
+ order by 1 """
cursor.execute(sql % {'db':dbName})
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
Searchable Archives: http://leafe.com/archives/search/dabo-dev
This message:
http://leafe.com/archives/byMID/[email protected]
