myLittleAdmin Features

myLittleAdmin Features

Connection

• SQL Server and Windows authentication
• Network protocols and other options

Databases

• System, Snapshot and User databases
• List
• Create, delete, rename
• Properties, Permissions, Extended Properties

Tables

• System and User tables
• List
• Create, delete, rename, modify
• View dependencies
• Quick data edit
• Export data to XLS, XML, CSV
• Properties, Permissions, Extended Properties

Columns

• List
• Create, delete, rename, modify
• Properties, Extended Properties

Keys

• Foreign and primary keys List
• Create, delete, rename, modify

Constraints

• List
• Create, delete, rename
• Properties, Extended Properties

Triggers

• List
• Create, delete, rename, modify
• View dependencies
• Extended Properties

Indexes

• List
• Create, delete, rename
• Properties, Extended Properties

Statistics

• List
• Create, delete
• Properties

Views

• System and User views
• List
• Create, delete, rename, modify
• View dependencies
• Export data to XLS, XML, CSV
• Properties, Permissions, Extended Properties
• Columns, Triggers, Indexes, Statistics

Synonyms

• List
• Create, delete
• Properties, Permissions, Extended Properties

Stored Procedures

• System and User stored procedures
• List
• Create, delete, rename, modify
• View dependencies
• Properties, Permissions, Extended Properties
• Parameters list

Functions

• System and User table-valued functions
• System and User scalar-valued functions
• List
• Create, delete, rename, modify
• View dependencies
• Properties, Permissions, Extended Properties
• Parameters list

Database Triggers

• List
• Create, delete, modify
• Extended Properties

Assemblies

• List
• Delete

Types

• System data types, User-defined data types, User-defined types, XML schema collections
• List
• Create, delete, rename, modify
• View dependencies
• Properties, Extended Properties

Rules

• List
• Create, delete
• View dependencies
• Properties, Extended Properties

Defaults

• List
• Create, delete
• View dependencies
• Properties, Extended Properties

Service Broker

• Message types, Contracts, Queues, Services, Routes, Remote Service Binding
• List
• Delete

Storage

• Full Text Catalog, Partition Schemes, Partition Functions
• List
• Create, Modify, Delete

Users

• List
• Create, Rename, Delete
• Properties, Extended Properties

Roles

• Database roles, Application roles
• List
• Create, Rename, Delete
• Properties

Schemas

• Database roles, Application roles
• List
• Create, Delete, Modify
• Properties, Permissions, Extended Properties

Symetric and Asymetric Keys

• List
• Delete
• Properties

Certificates

• List
• Delete
• Properties

Logins

• List
• Create, Delete, Modify
• Properties

Server roles

• List
• Properties

Credentials

• List
• Delete
• Properties

Backup devices

• List
• Create, Delete
• Properties

Linked servers

• List
• Delete
• Properties

Server Triggers

• List
• Create, Delete, Modify

Error log

• List

Activity monitor

• Process List

Tools and wizards

• New query tool
• Generate INSERT script wizard
• CSV Import wizard
• Backup wizard
• Restore wizard
• Detach wizard
• Attach wizard
• Shrink database wizard
• Change password wizard

Preferences

• Multi language
• Multi skin

Misc

• Ability to enable/disable each feature
• Ability to get the T-SQL script of each action
• Silent logon module
• and much more!