Get the Column Default Value in MySQL Database

Question

Hello I have database which consists of many columns And I have one field with default value let say the default value of that field is FOLDERNAMEhow can I can get that FOLDERNAMEThanks

Shashikant · Accepted Answer

Please refer below scriptSELECT COLUMNDEFAULT AS DefaultValue FROM INFORMATIONSCHEMACOLUMNS WHERE TABLENAME39TableName39 AND COLUMNNAME  39ColumnName39

Get the Column Default Value in MySQL Database

Company

Explore

Follow us

Contact Us