Rename multiple files using windows command prompt -

i have several files name format dbo.table_name.sql , want rename them table_name.1.tbl how using windows cmd prompt?

i have tried ren *.sql *.1.tbl rename dbo.table_name.1.tbl still not able remove dbo. here.. tried ren dbo.*.sql *.1.tbl still not luck :(

a batch file work.

@echo off
setlocal enabledelayedexpansion
%%f in (dbo*.sql) (
set "name=%%~nf"
ren "!name!.sql" "!name:dbo.=!.tbl"
)