Export (0) Print
Expand All
0 out of 1 rated this helpful - Rate this topic

How to: Create Tables (Visual Database Tools)

Using Table Designer, you can create a new table, name it, and add it to an existing database.

NoteNote

If you are connected to a SQL Azure database, the new table option launches a create table template script. Edit the parameters, then run the script to create a new table. For more information, see SQL Azure Overview.

To create a new table with Table Designer

  1. Right-click the Tables node of your database in Object Explorer and click New Table.

  2. Type column names, choose data types, and choose whether to allow nulls for each column.

  3. From the File menu, choose Save table name.

  4. In the Choose Name dialog box, type a name for the table and click OK.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.