Re: Querying value of lower_case_table_names

2005-08-07 Thread Gleb Paharenko
Hello.



What about this:



mysql show variables like 'lower_case_%';

++---+

| Variable_name  | Value |

++---+

| lower_case_file_system | OFF   |

| lower_case_table_names | 0 |

++---+



I think it is possible to make a stored procedure in MySQL 5 which 

will be a wrapper for 'show ...' statement.







Hi,

 

 Is there any way to check value of of 'lower_case_table_names'? I need

 to an equivalent of  (MS Sql Server statement)

  

   exec sp_server_info @attribute_id=16



Sunil Vishwas [EMAIL PROTECTED] wrote:



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
   ___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Querying value of lower_case_table_names

2005-08-05 Thread Sunil Vishwas
Hi,
 
Is there any way to check value of of 'lower_case_table_names'? I need
to an equivalent of  (MS Sql Server statement)
 
exec sp_server_info @attribute_id=16
 
Thank you,
Sunil Vishwas