Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Basically, I want to list all the SQL files from a folder called Scripts. I am doing this in the following way:

dir /s /b "D:\Scripts\*.sql"

(I am specifying the full path as I want this to work from wherever I write this command)

This is showing me the list of files somewhat like:

D:\Scripts\subfolder1\foo.sql
D:\Scripts\subfolder1\bar.sql
D:\Scripts\subfolder2\baz.sql

I would like to print just:

foo.sql
bar.sql
baz.sql

Is this possible from a single command? Thanks in advance.

share|improve this question
up vote 2 down vote accepted
for /r D:\Scripts %a in (*.sql) do @echo %~nxa
share|improve this answer
for /f "tokens=*" %a in ('dir /s /b "D:\Scripts\*.sql"') do echo %~nxa
share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .