Tech-Wonders.com

Menu
  • Apps
  • How To
  • Gadgets
    • Mobile
  • Software
  • Technology
  • Sitemap
  • Contact Us

Tech-Wonders.com » Software

Database Creation in FoxPro

Database Creation:-

Each field stored in a table is given a field name and a data type. The data type or a field determines what type of data can be stored in it and the amount of storage space available for the data.

Creation rules have to be followed while entering the field names which are as follows:

  1. Can have a maximum of 10 characters.
  2. Can comprise alphabet both uppercase and lowercase(A-Z and a-z), digits 0 to 9 and underscore(_)
  3. Must start with an alphabet.


Go to Start >> Programs >> FoxPro for Windows
It then displays the FoxPro window with command window. We have to type commands in the command window. Typing the command ‘Clear’ and pressing enter clears the screen.

Create a Table:-

  1. Type the command ‘Create Student’ and press enter which displays the table structure dialogue box.
  2. If prompts to input data records now, click Yes and after inputting the data click OK.
  3. This displays the input record table ‘Student’. Press Tab to move the active cell.
  4. To save a record type ‘Ctrl + W’. Again for displaying list in table, type list in the command box and hit enter.
  5. To close the existing table, use the command Close all and to open the table again, type the command – use and hit enter. Here to display our student table we have to type use student and then hit enter.
  6. Dir command is used to display the database table Student consisting of Database files (DBF).
  7. To come out of FoxPro use the command ‘Quit’

Tweet
Share
Linkedin
Whatsapp
Reddit
Email
Prev Article
Next Article
Tags:Databases FoxPro Microsoft database software

Leave a Reply Cancel Reply

Recent Posts

  • What is a Server Farm? 5 Essential Insights
    What is a Server Farm? 5 Essential Insights
  • Bitcoin’s Fee-to-Reward Ratio Underlines the Blockchain’s General Stability
    Bitcoin’s Fee-to-Reward Ratio Underlines the Blockchain’s General Stability
  • Tips to Maximize Productivity for Your Company
    Tips to Maximize Productivity for Your Company
  • 10 Reasons to Hire an Android Application Development Company for Your Next Project
    10 Reasons to Hire an Android Application Development Company for Your Next Project
  • Different Ways to Scratch That Gaming Itch
    Different Ways to Scratch That Gaming Itch

Categories

  • Apps
  • Big Data
  • Blog
  • Books and Reviews
  • C Programming Language
  • Cars
  • Certifications
  • Chemistry
  • Computers
  • Data Warehousing
  • Ecommerce
  • Electrical
  • Electronics
  • Engineering
  • Entrepreneurs
  • Facebook
  • Featured
  • FinTech
  • Fuzzy Logic
  • Gadgets
  • Games
  • Gmail
  • Google
  • Google Plus
  • Health Tech
  • How-to Topics
  • Infographics
  • Instagram
  • Internet
  • Java Programming Language
  • JavaScript
  • Jobs
  • LinkedIn
  • Marketing
  • Mathematics
  • Microsoft
  • Mobile
  • Numismatics
  • Online Earning
  • Pinterest
  • Plagiarism
  • Programming Languages
  • Python Programming Language
  • Real Estate
  • Road Transport
  • Salesforce
  • Science and Technology
  • Security
  • SEO
  • Social Media
  • Social Networking
  • Software
  • SQL
  • Swift Programming Language
  • TikTok
  • Travel
  • Troubleshooting Tips
  • Twitter
  • Web Designing and Development
  • Websites
  • Windows
  • WordPress
  • YouTube Tips and Tricks

Tech-Wonders.com

Technology Blog

About the Admin

RamaRao Bobby Hi there! I am RamaRao Bobby, Founder and Editor-in-Chief of
Tech-Wonders.com, Kakinada’s Top Technology Blog.

I am an avid Dog Lover and Tech Enthusiast. Read More

  • Archives
  • Disclaimer
  • Privacy Policy
  • Featured Comments

Recent Comments

  • Vijay Kumar on Google People Cards: What is It and How to Register?
  • Pravin Mohite on Best Top 10 Marathi Websites and Blogs
  • Marathi Blogger on Best Top 10 Marathi Websites and Blogs
  • Krish on Best Telugu Websites and Telugu Blogs
  • Luke Smith on The Importance of Access Control Systems in Enhancing Business Security

Always Remain in Touch

Subscribe

Copyright © 2023 Tech-Wonders.com