Non-schema Objects
Other types of objects are also stored in the database and can be created and manipulated with SQL, but are not contained in a schema:
- Assemblies
- DDL Triggers
- Partition Functions
- Partition Schemes
- Full-Text Catalogs
- Symmetric Keys
- Asymmetric Keys
- Certificates
- Message Types
- Contracts
- Services
- Routes
- Remote Service Bindings
Use the DB Explorer tree to navigate within the database(s) and the objects.