OraFAQ Forum: MySQL » View default values

Home » Open Source » MySQL » View default values (MySQL 5.1)

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

View default values [message #501059]

Fri, 25 March 2011 08:17

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.

Report message to a moderator

Re: View default values [message #501060 is a reply to message #501059]

Fri, 25 March 2011 08:19

joy_division
Messages: 4266
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.

Report message to a moderator

Re: View default values [message #501061 is a reply to message #501060]

Fri, 25 March 2011 08:38

Michel Cadot
Messages: 54162
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Joy, it is a MySQL question not an Oracle one. Wink

Regards
Michel

Report message to a moderator

Re: View default values [message #501074 is a reply to message #501061]

Fri, 25 March 2011 11:20

joy_division
Messages: 4266
Registered: February 2005
Location: East Coast USA

Senior Member

Yep, didn't notice that until I saw that it was "moved."

Report message to a moderator

Re: View default values [message #501428 is a reply to message #501059]

Tue, 29 March 2011 02:13

Frank Naude
Messages: 4379
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....

Report message to a moderator

Previous Topic:	how to install sqlserver 2005
Next Topic:	Date Prob In MySQL

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 21 10:14:10 CDT 2013

Total time taken to generate the page: 0.08938 seconds