Step 1
To create a table in SQL Server 2000, go to Enterprise Manager, expand Databases and then select a database that you want your table to reside.
Expand it and right click to make the menu popup. There select New Table
Step 2
The another window will appear. Then enter the appropriate field name and data type.
In this example we are trying to create an employee table with Employee name set to varchar(50) and EmployeeID to char(10).
No comments:
Post a Comment