|
Index is a way of finding out data quickly based on the values in the columns. Indexes are created o....
|
|
|
|
Constraints are the properties assigned to a single column or multiple columns to prevent inconsiste....
|
|
|
|
No. Both are used to assign value to the variables, but are different. SET uses ANSI standard while ....
|
|
|
|
No, if someone is using the databse then the datbase can't be renamed . For renaming the database we....
|
|
|
|
sp_rename 'olddatabasename' 'newdatbasename'
|
|