Can you create a table with indexes at the same time?
Posted
by Maslow
on Stack Overflow
See other posts from Stack Overflow
or by Maslow
Published on 2010-04-06T16:03:47Z
Indexed on
2010/04/06
16:13 UTC
Read the original article
Hit count: 291
Filed under:
sql
|sql-server
I'd like to create a table:
CREATE TABLE sfc.OpenId (
Url VARCHAR(255) PRIMARY KEY,
UserGuid uniqueidentifier NOT NULL references dbo.aspnet_users(userId),
)
...with an index on UserGuid.
Is it possible to create that index in the create table statement?
© Stack Overflow or respective owner
