Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2008
    Posts
    7

    Post Unanswered: Need tips to create a database in Sybase

    Hi,

    Anyone provide tips to create a database

    Thanks!!!!!!!

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Well, most employers don't tip. They offer a flat rate.

  3. #3
    Join Date
    Jun 2009
    Posts
    25
    The general syntax for creation of a database in sybase is as follows
    create database database_name
    [on {default | database_device} [= size]
    [, database_device [= size]]...]
    [log on database_device [= size]
    [, database_device [= size]]...]
    [with override] - optional only when you put log and data on the same logical device(not recommended)
    [for load] - optional supposed to be given only when user is ready to load the dump of userdatabase immediately after creation of the database. If the database created is new then there is no need for a forload option.

    For additional information please refer system administration guide.
    Last edited by erovij; 02-04-10 at 02:57.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •