• SQL

    Add Columns, Delete Columns, and Edit Columns, and Find Love Using SQL ALTER Statements

    Previously, we covered creating tables in SQL. To create a column in a table, use the ALTER TABLE statement, along with the ADD and then define a column name followed by the data type: ALTER TABLE nameoftable ADD nameofcolumn datatype To delete a column in a table:: ALTER TABLE nameoftable DROP COLUMN nameofcolumn To change the type of data stored in a column, use MODIFY: ALTER TABLE nameoftable MODIFY COLUMN nameofcolumn datatype In this article, we’ll use the same “Customers” table from our first articles to add and edit columns: ID Site Contact Address City Zip Country 1 Krypted Charles Edge my house Minneapolis 55418 US 2 Apple Tim Cook…

  • Active Directory

    Extend the AD Schema in 2008 Server using ldifde

    To import directory objects, at the command prompt, type the following command, and then press ENTER:  ldifde–i-ffilename-sservername:port-m-ausername domain password To export directory objects, at the command prompt, type the following command, and then press ENTER:  ldifde-e-ffilename-sservername:port-m-ausername domain password