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
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
Logins
- List
- Create, Delete, Modify
- Properties
Backup devices
- List
- Create, Delete
- Properties
Server Triggers
- List
- Create, Delete, Modify
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!
