Re: MS SQL server Meata data question
From: Andy Hassall (andy_at_andyh.co.uk)
Date: 01/13/04
- Next message: CountScubula: "Re: imagecreatefrom and dynamic graphics"
- Previous message: Henk Verhoeven: "Re: chinese and arrays"
- In reply to: Tom Jones: "MS SQL server Meata data question"
- Next in thread: Jochen Daum: "Re: MS SQL server Meata data question"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Tue, 13 Jan 2004 00:24:06 +0000
On Mon, 12 Jan 2004 18:32:36 -0500, "Tom Jones" <tomjones@lucent.com> wrote:
>I need to do this for Oracle too but I think the native support for Oracle
>is better and the tools built in ... I think Oracle supports something they
>call show commands that just do what I want.
No idea about SQL Server, never used it. However, in Oracle, you look in the
'data dictionary' for metadata; it's a set of views such as USER_TABLES,
USER_TAB_COLUMNS that you query with ordinary SQL.
See: http://otn.oracle.com/pls/db92/db92.catalog_views?remark=homepage
'SHOW' commands are for MySQL - such as 'SHOW TABLES'. You can execute these
as queries and they return a result set, but they're not proper SQL as you
can't have WHERE clauses or use them in joins etc.
-- Andy Hassall <andy@andyh.co.uk> / Space: disk usage analysis tool <http://www.andyh.co.uk> / <http://www.andyhsoftware.co.uk/space>
- Next message: CountScubula: "Re: imagecreatefrom and dynamic graphics"
- Previous message: Henk Verhoeven: "Re: chinese and arrays"
- In reply to: Tom Jones: "MS SQL server Meata data question"
- Next in thread: Jochen Daum: "Re: MS SQL server Meata data question"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
