Here is my create table command
CREATE TABLE EXCLUSIVEITEM(VIEW_ID INTEGER NONCLUSTERED IDENTITY(1,1)PRIMARY KEY,
VIEW_LATEST_REPLY_DATE CLUSTERED INDEX DATETIME)
Is this the way to create one of my columns clustered. The books that I have all use stored procedure I only want to use regular sql commands. Is this possible?Indexes are clustered, columns aren't.
Can you post the assignment as you received it, or give us a URL to it? I'm still not clear on what you're trying to do, so I'm not much help in doing it!
-PatP
Wednesday, March 21, 2012
How to make a column clustered
Labels:
clustered,
column,
commandcreate,
create,
database,
exclusiveitem,
identity,
integer,
key,
microsoft,
mysql,
nonclustered,
oracle,
primary,
server,
sql,
table,
view_id,
view_latest_reply_date
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment