Home » Open Source » MySQL » View default values (MySQL 5.1)
View default values [message #501059] Fri, 25 March 2011 08:17 Go to next message
oraarvind
Messages: 2
Registered: March 2011
Location: India
Junior Member

Hi all,
My intention is to get default value from one of the String column in VIEW.
I do not know how to get it.
Please help me in this issue.
Thanks in advance.
Re: View default values [message #501060 is a reply to message #501059] Fri, 25 March 2011 08:19 Go to previous messageGo to next message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
Find the underlying table(s) by looking at USER_VIEWS.
From there you can look at USER_TAB_COLUMNS.
Re: View default values [message #501061 is a reply to message #501060] Fri, 25 March 2011 08:38 Go to previous messageGo to next message
Michel Cadot
Messages: 68617
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Joy, it is a MySQL question not an Oracle one. Wink

Regards
Michel
Re: View default values [message #501074 is a reply to message #501061] Fri, 25 March 2011 11:20 Go to previous messageGo to next message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
Yep, didn't notice that until I saw that it was "moved."
Re: View default values [message #501428 is a reply to message #501059] Tue, 29 March 2011 02:13 Go to previous message
Frank Naude
Messages: 4578
Registered: April 1998
Senior Member
oraarvind wrote on Fri, 25 March 2011 15:17
My intention is to get default value from one of the String column in VIEW.

SQL> SHOW FIELDS FROM my_table_name;

Alternatively, SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE....
Previous Topic: how to install sqlserver 2005
Next Topic: Date Prob In MySQL
Goto Forum:
  


Current Time: Mon Mar 18 23:55:36 CDT 2024