Results 1 to 2 of 2

Thread: Creating Multiple Keys in an SQL DB

  1. Oct 29th, 2006, 09:52 AM #1
    Wolverchenus
    Wolverchenus is offline

    Thread Starter
    Member
    Join Date
    Aug 2004
    Location
    Israel
    Posts
    54

    Creating Multiple Keys in an SQL DB

    How do I choose multiple keys in an SQL database table after creating it? (In code of course)

    cheers.
    It doesn't matter whether you win or lose as long as you win.
    Reply With Quote Reply With Quote
  2. Oct 29th, 2006, 12:54 PM #2
    Mr.No
    Mr.No is offline
    Fanatic Member Mr.No's Avatar
    Join Date
    Sep 2002
    Location
    Mauritius
    Posts
    651

    Re: Creating Multiple Keys in an SQL DB

    I'll assume you're using SQL Server.
    VB Code:
    1. sql = "create index dbo..ndx_phone_firstname on customer(phone, firstname)"
    Using VB.NET 2003/.NET 1.1/C# 2.0
    http://del.icio.us/rajoo
    Blow your mind, smoke gunpowder
    Ashes to ashes, dust to dust
    If God won't have you, the devil will. - Author unknown
    Don't follow me, I'm lost too ...
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width