![]() The CREATE command is used to create a new database object in a database such as tables, views, functions, etc. Let’s discuss each of these Data Definition Language commands in detail. Those are (CREATE, ALTER, SP_RENAME, TRUNCATE, DROP) DDL commands are working on the structure of a table, not on the data of a table.that means DDL statements are used to alter/modify a database or table structure and schema Data Definition Language (DDL) is used to define database objects such as tables, synonyms, views, procedures, functions, triggers, etc.TCL (3 commands- commit, rollback, savepoint).DML (3 commands- Insert, Update, Delete).DDL (5 commands- create, alter, sp_rename, drop, truncate).It means that all the SQL Commands are almost similar to normal English language SQL can be called NLI (Natural Language Interface).Every command of SQL should end with a semicolon ( ) (It is optional for SQL Server).SQL is not a case-sensitive language it means that all the commands of SQL are not case sensitive.The sequel will provide a common language interface facility it means that a sequel is a language that can communicate with any type of database such as SQL Server, Oracle, MySQL, Sybase, BD2, etc.SQL is also called Sequel it stands for Structured English Query Language,.ANSI (American National Standard Institute) approved this concept and in 1972 SQL was released into the market.This Language was developed by the German Scientist Mr.It is a non-procedural language that is used to communicate with any database such as Oracle, SQL Server, etc.What are the differences between the delete and truncate commands in SQL Server?. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |