Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Incident Reports » Incident Reports Addressed for Version 2.12 » View Incident Report |
Minor |
Reported By: Barry McClure Reported On: 1/30/2013 For: Version 2.11 Build 3 |
CREATE VIEW "vTableIndexes" AS select "TableName", list(IndexDir) as "IndexColNames" from (select "TableName", "ColumnName"+if("Descending",' Desc','') as "IndexDir" from "information"."indexcolumns" order by "tablename", "indexname", "ordinalpos") as T1 group by "tablename", "IndexName"; select * from vTableIndexes where IndexColNames like 'p%';
This web page was last updated on Wednesday, March 20, 2024 at 07:22 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |