Listing of files in a directory using command prompt

Sometimes we need to deploy the DB objects using cmd prompt. When we are creating a build we need to provide the files name in the deployment sequence in a text file. If we have less SQL script then it is easy to write the file names in the text file. Think we have more SQL script then it will be a bit tedious task to write the files named in the text file.

With the help of CMD commend we can easily write the files name into the text file.

dir /b > File_Name.txt

Let’s see

In this folder, I have 43 file

 

I need to get the names of these files into a text file named “File_Name.txt”

Lunching the CMD

 

Now I we need to fire the commend

 

File created successfully.

Open the file.

Get the list of files.