Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
gds
Starting Member
29 Posts |
 Posted - 2001-03-22 : 21:52:12
|
| GOOD DAY TO YOU ALL SQL SEVER SYS-ADMIN. Example : CREATE TABLE dummy ( Empid char(7) PRIMARY KEY NOT NULL, EmpName char(30) ); Once you set the Empid field to be primary key, will it also create an index automatically? How about for foreign Key fields, will it also create an index automatically? P.S. I just want to make sure. |
|
|
|
|
|
SQL Server: Primary, Foreign Key, Indexes