Apart from the show tables command, or show tables like '%blah%', or describe <tablename>, are there any other queries you can use to simulate the
select name from sysobjects where type = 'u'
query in sql server?
basically I'd like to query the system tables directly, and to be able to control (via aliasing) the headings of each column. Can't alias the output of show tables, as far as I know.
Thanks
Daniel Morphett
Web Developer, DBA
www.daemon.com.au ---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
MX Downunder AsiaPac DevCon - http://mxdu.com/
