How can I remove foreign keys through SQL Server 7.0/2000 Enterprise Manager?
To drop foreign keys, you can do the following: 1. Run SQL Server Enterprise Manager. 2. Expand a server group; then expand a server. 3. Expand Databases; then expand appropriate database. 4. Click Tables; then right-click the table and choose ‘Design Table’. 5. Click the ‘Table and Index Properties’ button on the top menu. 6. On the ‘Relationships’ tab choose appropriate relationship and click ‘Delete’ button. You can also drop foreign keys from the diagrams in the Enterprise Manager (make diagram and drop foreign keys).
Related Questions
- When I create or edit a stored procedure or trigger through SQL Server Enterprise Manager, pressing the TAB key changes the context to each button. How can I indent my Transact-SQL statements?
- Will I have to upgrade my license keys in order to use the new version of Idera SharePoint enterprise manager?
- Why does opening the database folder in SQL Server Enterprise Manager 2000 take a long time?
