[cfaussie] Re: Test for SQL Table

Sun, 15 May 2005 21:44:20 -0700

sorry
 
the TYPE needs to be like that
 
EXEC sp_tables syscolumns, dbo, Company, "'SYSTEM TABLE'"
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Shane Farmer
Sent: Monday, May 16, 2005 2:34 PM
To: CFAussie Mailing List
Subject: [cfaussie] Re: Test for SQL Table

Steve,
 
Do you mean exec sp_tables 'table_name' ?
 
With this you can even use '%ble%' to get like matches.
 
Shane
--- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
---
You are currently subscribed to cfaussie as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/

Reply via email to