Delete by some dynamic command, where someone can delete some key data with a specific dynamic condition, it can delete one specific or multiple rows as well based on the provided condition. There is normally three kind of delete available in T-SQL commands, delete by using some cursor commands, where deleting some specific key column data by mentioning in the cursor. Delete : Using for deleting table, specific column of the table, specific row of the table or entire data inside the table.Create a view command actually helps to create the same. Now calling the view directly except this query execution it will give a result much faster than usual. Suppose there has some specific query which actually taken a long time to execute, in that case, we can define that specific query as a temporary table and create one new view with this temporary table executed data. Create view : Using this we can able to create one view.Create table : It is used for creating a new table with a specific definition, create table can use for some new table with default tablespace, for using some define tablespace on creating new table need to define the same with the create statement.Alter table column can also be used in case of rename table as well. Alter table: Basically use for altering one existing table column definition, or add one new column or delete one already added column.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |