First Step to Create a Database for your Website

Learn here in details about Database creation for your website

Hello friends, with database management systems, you need to create your tables before you can enter data. Just as you can create a database programmatically, you can create your tables programmatically too. 

Database Table Program

The following is an example of creating a new table. Note that we are specifying the name of the table, the name of each column, and the data type of each column. More parameters can be added to this example if your requirements are more specific.
Copy to Clipboard
(IndividualId int,
FirstName Varchar(255),
LastName Varchar(255),
DateCreated dateTime

User Interface

Database management systems usually have a "Design View" for creating tables. Design view enables you to create the names of each column, specify the type of data that can go into each column, as well as specifying any other restrictions you'd like to enforce. Restricting the data type for each column is very important and helps maintain data integrity. For example, it can prevent us from accidentally entering an email address into a field for storing the current date.
More parameters can be added against each column if you require them. For example, you could specify a default value to be used (in case the field has been left blank by the user).

When you create a table via the user interface (or design view), depending on which database system you use, you should see something like this:
Once you've created your table in "design view", you can switch to "datasheet view" to see the resulting table. You should see something like this:
OK, so this is a blank table - it doesn't have any data yet. What we have is a table that contains the columns required before we can enter any data.
So, now that we have a blank table, let's look at how to add data.

First Step to Create a Database for your Website First Step to Create a Database for your Website Reviewed by Vishal Jaiswal on January 18, 2015 Rating: 5

No comments:

1. Don't make SPAM comment.
2. Don't try to make backlinks in comment text.
3. Use Name/URL, Google profile or Anonymous option.
4. Ask your problem.

Powered by Blogger.