Specify table characteristics. Specify schema binding and encryption for stored procedures, triggers, user-defined functions, and views. Specify recompile settings for stored procedures. Specify index characteristics. Alter database objects to support replication and partitioned views.
Support merge, snapshot, and transactional replication models.
Design a partitioning strategy. Design and create constraints and views. Resolve replication conflicts. Troubleshoot failed object creation. Retrieving and Modifying Data Import and export data.