How to create a new table?

Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.

How to create a new table?

Rating:

Take the following steps to create a new table:

  1. Run SQL Server Management Studio from Start > Programs > Microsoft SQL Server 2005 > Microsoft SQL Server Management Studio.



  2. In the Connect to Server dialog box, select the Server type as Database Engine, specify the Server name, Authentication, and click the Connect button.



  3. Double-click the Databases folder.



  4. Double-click the MyData (a database in which you want to create the table) database.



  5. Right-click the Tables folder and click the New Table option.



  6. Mention the column names, their datatypes , and specify whether or not the column should accept null values.



  7. On the File menu, click the Save Table_1 option.



  8. In the Choose Name dialog box, mention the name of the table, and click the OK button.



  9. Double-click the Tables folder.



  10. The table that is created will be displayed.




Rating:



Other articles

Click here to Article home

Microsoft Certification MCSE: MCSA , MCTS, MCDST, MCAD, MCDBA, MCSE Messaging, MCSE Security
JAVA Certification: SCJP, SCWCD Cisco Certification: CCNA, CCENT, A+, Network+, Security+
Oracle Certification: OCP 9i, OCP 10g, OCA 9i, OCA 10g CIW foundation    EC-212-32    CISSP    Photoshop ACE    Adobe Flash ACE
© 2008 uCertify.com. All rights reserved. All trademarks are the property of their respective owners.
 
HACKER SAFE certified sites prevent over 99.9% of hacker crime.