DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 5 of 5

Thread: Needing exact coding steps that must be done to create an SQL database

  1. #1
    Join Date
    May 2005
    Posts
    2

    Question Needing exact coding steps that must be done to create an SQL database

    Hello,
    I have changed my post question quite a bit, so here is the NEW post.

    I am new to SQL and Databases. I have never created a database before.

    Can someone please tell me the coding steps that must be done to create a new and complete database???

    For example, I know that you have to create a Table and assign fields to it, but what coding do you do before this step????? Also, what coding do you do after this step???

    Again, I ask that you please tell me each coding step that is needed and required to create a complete database???


    Thanks,

    Bobby Howerton

  2. #2
    Join Date
    Nov 2003
    Location
    Portland, OR
    Posts
    8,387
    In which programming language?
    Phil Weber
    http://www.philweber.com

    Please post questions to the forums, where others may benefit.
    I do not offer free assistance by e-mail. Thank you!

  3. #3
    Join Date
    May 2005
    Posts
    2
    I am sorry I will be creating the tables, assigning values, etc. with SQL.

    So I guess the answer to your question is that I will be coding in the
    "SQL" programming language.

    I hope that you understand what I am talking about and what I am wanting to do.

    Thanks,

    Bobby Howerton

  4. #4
    Join Date
    Nov 2003
    Location
    Portland, OR
    Posts
    8,387
    I did a Google search for "oracle create table" and found the following:

    http://www.uwm.edu/~derek/course/Tools/CS/orcreate.html
    http://www-db.stanford.edu/~ullman/f.../or-intro.html
    Phil Weber
    http://www.philweber.com

    Please post questions to the forums, where others may benefit.
    I do not offer free assistance by e-mail. Thank you!

  5. #5
    Join Date
    May 2005
    Posts
    12
    A simple database consists of a datafile and a transaction log file.

    USE master
    GO
    CREATE DATABASE Products
    ON
    ( NAME = prods_dat,
    FILENAME = 'c:\program files\microsoft sql server\mssql\data\prods.mdf',
    SIZE = 4,
    MAXSIZE = 10,
    FILEGROWTH = 1 )
    GO

    This code will automatically create transaction log file and the db will be ready for you to work named products.

    I hope this helps.

    MAnoj.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center