Configure Asterisk Dialplan Extension

Hello All,
So far I have created a Database in MySQL for SIP.config and have also configured it for SIP.config. But db integration is not working while removing the file from the server file directory.
Also I am having confusions a lot while configuring a database table for Dialplan extensions. Exactly I cannot understand where should I have to mention the db table name in extension.config.
Please advice. Thanks in advance for all the efforts to help me.

If you are just starting out, then I would recommend chan_PJSIP instead of chan_SIP – they are both SIP – but chan_PJSIP is newer and chan_SIP is being deprecated.

As for a table for your dial plan, instead you might want to start with a static /etc/asterisk/extensions.conf file and then use func_ODBC to populate specific variables as-needed.