DDL (Data Definition Language) DDL or Data Definition Language actually consists of the SQL commands that can be used to define the database schema. It simply deals with descriptions of the database schema and is used to create and modify the structure of database objects in the database. DDL is a set of SQL commands used to create, modify, and delete database structures but not data. These commands are normally not used by a general user, who should be accessing the database via an application. List of DDL commands: CREATE : This command is used to create the database or its objects (like table, index, function, views, store procedure, and triggers). DROP : This command is used to delete objects from the database. ALTER : This is used to alter the structure of the database. TRUNCATE : This is used to remove all records from a table, including all spaces allocated for the records are removed. COMMENT : This is used to add comments to the data dictionary. RENAME :...
CREATE TABLE MCA2022( ID INT, NAME CHAR(10), YEAR CHAR(8), PIN_CODE INT);
ReplyDeleteINSERT INTO MCA2022 VALUES( 4 , 'Lucky Yadav', '1st Year' , 208024 );
CREATE TABLE MCA2022( ID INT, NAME CHAR(10), YEAR CHAR(8), PIN_CODE INT); // CREATE TABLE
ReplyDeleteINSERT INTO MCA2022 VALUES( 5 , 'Lucky Yadav', '1st Year' , 208024 ); // INSERT DATA IN THE TABLE
ALTER TABLE MCA2022
ALTER COLUMN NAME CHAR(15); // TO UPDATE THE SIZE OF THE COLUMN AND DATA TYPE
ALTER TABLE MCA2022
ADD 4DIGIT_ROLL_NO INT; // ADD COLUMN IN TABLE
SELECT
ReplyDelete* FROM [Customers Extended] T1,[Customers Extended] T2
WHERE T1.City= T1.City ;
Dim f As Object Dim strfile As String Dim strfolder As String
ReplyDeleteDim varitem As Variant
Set f Application.FileDialog(3)
f.allowMultiSelect = True
If f.show Then
For Each varitem In f.selecteditems
strfile = Dir(varitem)
strfolder Left(varitem, Len(varitem) - Len(strfile)) MsgBox "Folder" & strfolder & vbCrLf & "File:" & strfile
picturesource = strfolder + strile Next
End If Set f = Nothing