SQL Server Eng PART3
DDL (Data Definition Language) DDL is used to define and modify database structures (schemas). Main DDL commands: CREATE, ALTER, DROP, TRUNCATE, RENAME. CREATE is used to make new tables, views, stored procedures, functions, etc. ALTER modifies existing objects like adding/dropping columns, changing data types. DROP permanently deletes database objects. TRUNCATE removes all rows from a … Read more