Solving the problem of deleting the table
State the steps for “this message could not delete” from the particular tables?
Expert
This error is caused due to the delete query and when unique property is set to “no”.
Following given are the steps that must be followed in order to solve the problem.
1) Delete query must be opened and if it is not opening then press F4.
2) Clicking on the query properties underneath query designer will provide you the options.
3) In that options, you require to locate the unique records property and must set it to yes. These options are present in the query property sheet.
Write a short on the six database functions which occur during the systems development life cycle?
Describe any two reasons which show the necessity of database redesign?
Explain the term Repository Tables within the Data Stage?
Elucidate what are the basic requirements to join two sources in the source qualifier?
What occurs while rows are determined using a FETCH statement?
Illustrate the term indexing. Specify the kinds of the indexing.
Describe the difference between SQL Server 2000 clustered indexes and non clustered indexes?
Write down brief note on the differentiation between dynamic cache and static cache?
What is Relational Algebra?
Briefly describe the fundamental stages of Data Warehousing?
18,76,764
1929099 Asked
3,689
Active Tutors
1439094
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!