| MS SQL WEB ADMINISTRATION |
 |
|
| The following is a list of management features: |
|
|
|
|
Databases |
|
|
|
• List |
|
|
|
• Display used space |
|
|
|
|
Tables |
|
|
|
• List |
|
|
|
• Data search |
|
|
|
• Quick data edit |
|
|
|
• Create, delete, rename, generate SQL script |
|
|
|
• Export data to character-delimited files or XML files |
|
|
|
|
Columns |
|
|
|
• List |
|
|
|
• Create, delete, rename, edit |
|
|
|
|
Indexes |
|
|
|
• List |
|
|
|
• Create, delete, rename, generate SQL script |
|
|
|
• Rebuild |
|
|
|
|
Relationships |
|
|
|
• List |
|
|
|
• Create, delete, rename, generate SQL script |
|
|
|
|
Triggers |
|
|
|
• List |
|
|
|
• View T-SQL |
|
|
|
• Create, delete, rename, edit, generate SQL script |
|
|
|
|
Constraints (Checks) |
|
|
|
• List |
|
|
|
• Create, delete, rename, edit, generate SQL script |
|
|
|
|
Views |
|
|
|
• List |
|
|
|
• View T-SQL |
|
|
|
• Data search |
|
|
|
• Create, delete, rename, edit, generate SQL script |
|
|
|
• Export data to character-delimited files or XML files |
|
|
|
|
|
|
|
|
|
|
Stored Procedures |
|
|
|
• List |
|
|
|
• View T-SQL |
|
|
|
• Create, delete, rename, edit, generate SQL script |
|
|
|
|
Users |
|
|
|
• List |
|
|
|
|
Roles |
|
|
|
• List |
|
|
|
|
Rules |
|
|
|
• List |
|
|
|
• Create, delete, rename, generate SQL script |
|
|
|
• Link to UDT and columns |
|
|
|
|
Defaults |
|
|
|
• List |
|
|
|
• Create, delete, rename, generate SQL script |
|
|
|
• Link to UDT and columns |
|
|
|
|
User Defined Types (UDT) |
|
|
|
• List |
|
|
|
• Create, delete, rename, edit, generate SQL script |
|
|
|
|
User Defined Functions (UDF) |
|
|
|
• List |
|
|
|
• View T-SQL |
|
|
|
• Create, delete, rename, edit, generate SQL script |
|
|
|
|
Tools |
|
|
|
• Query analyser |
|
|
|
|
Options |
|
|
|
• Multi languages |
|
|
|
• Multi skins |
|
