How to change name to get rid of name in front of file names?

admin.campaign.sql
admin.cardnumber_filter.sql

understand that rename is using mv command but how do I rename such that it become the following:

campaign.sql
cardnumber_filter.sql

thanks

for file in admin.campaign.sql admin.cardnumber_filter.sql
do
        mv "$file" "${file#*.}"
done

The answer that bipinajith gave is a example of Parameter expansion. Check this link for more details.

Shell Command Language