Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 4 of 4 total |
Table exists? |
Fri, Aug 8 2008 8:16 AM | Permanent Link |
Francisco Fernandez | Hi.
Any way to ask database if a table exists? because it can be at the folder but not in the database. Thank you. |
Fri, Aug 8 2008 8:26 AM | Permanent Link |
Fernando Dias Team Elevate | Francisco,
You can search the "Information.Tables" table. For example: SELECT * FROM Information.Tables returns all tables in the database. -- Fernando Dias [Team Elevate] |
Fri, Aug 8 2008 8:30 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Francisco
>Any way to ask database if a table exists? because it can be at the folder but not in the >database. You need to query one of the system information tables. eg select Name from information.tables where Name = 'yourname' and check to see if it returns anything Roy Lambert [Team Elevate] |
Fri, Aug 8 2008 8:51 AM | Permanent Link |
Francisco Fernandez | Ok.
Thank you all |
This web page was last updated on Sunday, May 5, 2024 at 07:30 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |