Entry

Database: Microsoft SQL server: Table: Create: How create new table in Enterprise manager, manually?

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

----------------------------------------------------------------------
--- Knud van Eeden --- 22 December 2003 - 10:38 pm -------------------

Database: Microsoft SQL server: Table: Create: How create new table in 
Enterprise manager, 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 'Design table'

 9. -Possibly change some information

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. You are asked to supply a table name
        (if this table did not exist already)

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

----------------------------------------------------------------------