Become Joomla Developer

How To Create Table in SQL Server 2005

Creat Table

  1. Right Click on Tables in TestDabase(your database name)-> select New Tables...
    Create Table
  2. Enter Column Name and data type
    Enter Columns And Data type
  3. Click on Save button to save your table
    Click on Save Button
  4. After you click on Save button you will see a message box that allow you enter your Table Name. And then Click OK button
    Enter Table Name
  5. When you want enter data in to your table. You right click on your table name and then click on Open Table. Open Table
    If you click on Edit it will open SQL Statement that allow you edite your table by SQL Statement.
    If you want to Edite Column or Delect column you can click on Design that it allow can rename or insert columns name.
  6. After you click on Open Table. And then enter your data in to table.
    Enter Data

Suggestion | Contact US | About US | Term of Use | Privacy Policy | Advertiseing