How do I retrive the default value of a column? (I mean the deafult value you can specify when you create your table and that is assigned if you create a record without supplying data for that column).
select * from information_schema.columns where table_name = 'X' and column_name = 'X'
