SQL objects


SQL objects are

1) schemas,

2) data dictionaries, 

3) journals,

4) catalogs, 

5) tables, 

6) aliases, 

7) views, 

8) indexes, 

9) constraints, 

10) triggers, 

11) sequences, 

12) stored procedures, 

14) user-defined functions, 

15) user-defined types, 

16) and SQL packages. SQL creates and maintains these objects as system objects. 

A brief description of these objects follows:

Comments

Post a Comment

Popular posts from this blog

AIOMgr: Preparing flush failed with VERR_NOT_SUPPORTED, disabling async flushes

AIOMgr: Preparing flush failed with VERR_NOT_SUPPORTED, disabling async flushes If you get error like this while Installing Windows 8.1 as guest OS using Oracle VirtualBox /VirtualMachine Then check your RAM Allocation for the Guest OS. Example: First time i gave 5120 (5 GB) of RAM for Guest OS. while installing i got the error like this in log file AIOMgr: Preparing flush failed with VERR_NOT_SUPPORTED , disabling async flushes. Now i changed the RAM size to 4096(4 GB) , now the error gone, the guest OS installed successfully. My Suggestion is to set RAM size in EVEN  for this kind of errors.
Read more

The model type is invalid. please select an item from the list ( ASP.Net MVC)

Image
Hi, If any one face this problem, hear is one solution While creating/Add controller for Entity Framework in Asp.Net MVC3 OR MVC4 Example: As per this website Controller name:  MoviesController . (This is the default. ) Template:  Controller with read/write actions and views, using Entity Framework . Model class:  Movie (MvcMovie.Models) . Data context class:  MovieDBContext (MvcMovie.Models) . Views:  Razor (CSHTML) . (The default.) when we click on " Add" Button the application show one alert message "The model type is invalid. please select an item from the list " Before adding MoviesController we need to  built the project before proceed to this step. Click on Run Button to built the project and now add controller with above steps. I hope you problem will be solved.
Read more

Determine which service using port 80 in Windows

1) How to determine what software is using port 80 in WINDOWS netstat -aon | findstr 0.0:80 It will list all services which is using port 80 with PID (Process ID), The last one PID TCP    0.0.0.0:445             0.0.0.0:0              LISTENING       4 TCP    0.0.0.0:49152          0.0.0.0:0              LISTENING       524 TCP    0.0.0.0:49153          0.0.0.0:0              LISTENING       1012 2)  Port 80 is being used by SYSTEM (PID 4), How to stop IIS Services Open command prompt and type these command Taskkill /PID 4 /F If this will result like this  ERROR: The process with PID 4 could not be terminated. Reason: Access is denied. Then Type this command iisreset /stop now run this command...
Read more