Saturday, February 25, 2012

Create Index option in the table designer

Hi All,
In the table designer, I don't seem to find any option to create indexes.
Can indexes on tables be only created using the SQL Query Analyser?
kd
In Enterprise Manager, right click on the table and select
All Tasks and then Manage Indexes. Click on the new button
to create a new index.
If you are in design view of a table, you can right click in
the designer and select Indexes/Keys.
-Sue
On Mon, 11 Apr 2005 03:51:01 -0700, "kd"
<kd@.discussions.microsoft.com> wrote:

>Hi All,
>In the table designer, I don't seem to find any option to create indexes.
>Can indexes on tables be only created using the SQL Query Analyser?
>kd

No comments:

Post a Comment