write the use of create, alter, delete, comment.... please answer urgent
Answers
A ledger is the actual account head to identify your transactions and are used in all accounting vouchers. For example, purchase, payments, sales, receipts, and others accounts heads are ledger accounts. Without a ledger, you cannot record any transaction.
Answer:
A view is a T-SQL SELECT statement encapsulated in a SQL Server object. MSSQLTips.com previously published a quick and easy-to-read introduction to views. This tip digs more deeply into the topic with coverage of syntax, including how to drop views and alter views, data setup for a view, and different ways to use a view once it is created or modified.
There are at least two other SQL Server objects that can satisfy this top-level description of a view as one which encapsulates a SELECT statement. These other objects are stored procedures and inline table-valued user-defined functions. The encapsulation of the T-SQL SELECT statement makes it easier to extract data from multiple tables because you can return the outcome of a SELECT statement without re-specifying a complex join each time there is a need to run the SELECT statement. Views, along with both stored procedures and inline table-valued functions, can also permit the display of selected portions of underlying tables without granting read and write permissions to underlying tables. In this way, all three types of objects can enable access to some of the rows or some of the columns while still denying unrestricted access to all the rows and columns of a set of underlying tables. This feature can restrict access to sensitive data, such as salary or social security number
Explanation:
Drop View
If a view already exists with the same name as the one specified in a CREATE VIEW statement, then you need to drop the previously created view before invoking the CREATE VIEW statement for the new view. Otherwise, the CREATE VIEW statement will throw an error. You can use a DROP VIEW statement to remove a previously existing view from a database. You can drop a view simply by including its name at the end of a DROP VIEW statement. Again, you may prefer to qualify the view name with a schema name (Myschema.Myview).
Alter View
You do not need to drop a view if you want to modify it. Instead, you can change a previously existing view with the ALTER VIEW statement. This statement has the same design as CREATE VIEW statement, except that it modifies a previously existing view. An ALTER VIEW statement can be as simple as the following one. Notice that the syntax for CREATE VIEW and ALTER VIEW is the same. The ALTER VIEW statement requires a previously existing view with the same name in order to succeed, but the CREATE VIEW statement fails if there is a previously existing view with the same name.
plz mark me as brainliest