faqts : Computers : Databases : Microsoft SQL Server

+ Search
Add Entry AlertManage Folder Edit Entry Add page to http://del.icio.us/
Did You Find This Entry Useful?

0 of 1 people (0%) answered Yes
Recently 0 of 1 people (0%) answered Yes

Entry

Database: Microsoft SQL server: Table: Create: Manually: How to create a new table, manually?

Dec 22nd, 2003 13:05
Knud van Eeden,


----------------------------------------------------------------------
--- Knud van Eeden --- 22 December 2003 - 09:54 pm -------------------
Database: Microsoft SQL server: Table: Create: Manually: How to create 
a new table, manually?
---
Steps: Overview:
 1. -Open Microsoft SQL server 'Enterprise Manager'
 2. -Expand 'Microsoft SQL Servers' in the left pane
     (by clicking on the '+')
 3. -Expand 'SQL Server Group' in the left pane
     (by clicking on the '+')
 4. -Expand the server of your choice
     (e.g. your (local) (Windows NT) server
     (by clicking on the '+')
 5. -Expand 'Databases' (click on the '+')
 6. -Expand the database in which you want to
    add a table
    (e.g. click on the '+' of 'mydatabase')
 7. -Right click on 'Tables' in the list
 8. -Select from list 'New Table...'
 9. -Create some columns
     1. Fill in a name in the column 'Column name'
         e.g. 'Name'
     2. Choose a data type from the list in the column 'Data Type'
         e.g. varchar
        1. Choose a length (e.g. 40)
     3. Indicate if null or zero values are allowed in the
        column
10. -Important: expand this windows in order to see the
     menu (otherwise this menu is not shown) by clicking
     in the right corner on the window expand button
     [] (as usual in a Microsoft Windows window).
     So maximize the window.
11. -Save this table
     1. E.g. click on the floppy disk icon on the menu taskbar
     2. Supply a name for this table (e.g. email)
12. -Exit the program (e.g. click on the 'x' in the right corner
     of the window)
---
---
Internet: see also:
---
Database: Microsoft SQL server: SQL: Operation: Overview:Can you give 
an overview of SQL operations?
http://www.faqts.com/knowledge_base/view.phtml/aid/27560/fid/147
----------------------------------------------------------------------