thanks for ready and thanks for the suggestions. I have been using MySQL for a few years. My current project requires me to use MS SQL. I'm looking for a few pointer web links to learn about the differences in MySQL to SQL. I will also be using PHP so any PHP/SQL links are appreciated. My client requires me to give them a DDL file for their SQL Server team to integrate. Is a DDL the same as a .sql file? How can i create a DDL? Is there a way to make a SQL DDL have permission for create/edit/remove tables and that's about it? thanks
Not it is not! What are you talking about? DDL Scripts are any SQL scripts that affect the structure of a database. If this is a new application/site you are creating, they would prefer to have the DLL and the DML scripts (for data) separately for disaster recovery, creating test instances, etc.
It was a joke mate ! A Data Definition Language (DDL) is a computer language for defining data structures