answersLogoWhite

0

View is a virtual table with no data of its own. creating a view : create view taxpay as select * from employee where gross>5000;

User Avatar

Wiki User

10y ago

What else can I help you with?

Related Questions

What is the different between a view and a create view?

View is a virtual table that do not have any data of its own but have data that is derived from another table called base table. Create view is the command used to create a view (virtual table).


What is the difference between select into and createview command?

The SELECT INTO command creates a new table with data from an existing table whereas the CREATE VIEW command creates a view i.e., a virtual table from an existing table.


What is the command tool that can create delete view and modify objects in active directory?

Dsadd


What display command is used to create a magnified view by windowing a portion of a drawing?

The display command used to create a magnified view by windowing a portion of a drawing is typically the "Zoom" command, specifically the "Zoom Window" option. This allows users to select a rectangular area of the drawing, which then becomes the focus of the view, magnifying that section for detailed inspection. It’s commonly found in CAD software and similar applications.


What command clears the NetBIOS name cache table?

The command to clear the NetBIOS name cache table is nbtstat -R. This command releases and refreshes the NetBIOS name cache, effectively clearing it. You can run this command in the Command Prompt on a Windows system. Additionally, you can use nbtstat -S to view the current NetBIOS name cache entries.


What the purpose of the edit command in the system file checker?

Edit allows a user to view, create, or modify their computer files.


What is the output of the man command in Linux?

man has no output of its own. You must specify the name of the manual page you wish to view. For instance, to view the manual for bash, you would use the command man bash.


How do you create views?

Views can be created in a database using the CREATE VIEW key wordEx:CREATE VIEW view_name ASSELECT column_name(s)FROM table_nameWHERE conditions


How can you view files on a disc that was created from a command prompt?

You can easily see it as it looks like the normal file.


What command should you enter to view the host name and dns server address?

ipconfig / all


How can I create a printable list from the details view of a folder (in Windows)?

Running the MS-DOS DIR command and "piping" the results to a file does this.


When you create a blank database the table that Access creates for you contains one field named .?

If you create it in Design View, no field name is given. If you create it in Datasheet View it is called Field1.