Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you have been placed in read-only mode.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

Alter Table Add Index

3 Posts 2 Posters 0 Views 1 Watching

S Offline
S Offline
Shahzad Aslam

wrote on last edited by

#1

HI I want to add index in existing table. Can any person help me on this to generate script. What would be the syntax if possible give me example. Thanx Shahzad Aslam
E 1 Reply Last reply

0
S Shahzad Aslam

HI I want to add index in existing table. Can any person help me on this to generate script. What would be the syntax if possible give me example. Thanx Shahzad Aslam
E Offline
E Offline
Elina Blank

wrote on last edited by

#2

For SQL Server 2005: CREATE INDEX [IndexName] ON [TableName]([ColumnName])

Sincerely, Elina Life is great!!! Enjoy every moment of it! :-O
S 1 Reply Last reply

0
E Elina Blank

For SQL Server 2005: CREATE INDEX [IndexName] ON [TableName]([ColumnName])

Sincerely, Elina Life is great!!! Enjoy every moment of it! :-O
S Offline
S Offline
Shahzad Aslam

wrote on last edited by

#3

Thanx!
1 Reply Last reply

0

Log in to reply