Those types of queries will be available soon as the INFORMATION_SCHEMA
views are in development. Keep your eyes on the next few releases of
MySQL for this feature to appear (it may already be active in the 5.0.2
release just announced but I haven't had time to check yet). Until then
you will
[EMAIL PROTECTED] wrote:
Hi,
Thank you. But I want select the constraints and indices used on the
table. How can we get this information?. Please help me in this.
Ian gave you the answer:
From: Ian Sales
[...]
- show indexes from DATABASE_NAME.TABLE_NAME
The syntax is: SHOW INDEX FROM tablenam
(WT01 - TELECOM SOLUTIONS)
Cc: [EMAIL PROTECTED]
Subject: Re: Indices and Constraints.
[EMAIL PROTECTED] wrote:
>Need to know the similar one in MySQL. Do we have views or any other
>system tables in MySQL 4.0.21 which OUTPUTS the constraints and
indices
>in a particular table?
&g
[EMAIL PROTECTED] wrote:
Need to know the similar one in MySQL. Do we have views or any other
system tables in MySQL 4.0.21 which OUTPUTS the constraints and indices
in a particular table?
- show indexes from DATABASE_NAME.TABLE_NAME
- or, show create table DATABASE_NAME.TABLE_NAME;
- ian
--
My
Thats usually setup in the same table schema no ?
On 02/12/2004, at 9:52 PM, <[EMAIL PROTECTED]> wrote:
Hi All,
In oracle I can query user_constraints, user_indexes for getting the
constraints and indices for a particular table.
User_constraints and user_idexes are view which holds all the
constra