DML

[PravinBand]

Hi,

Who is agree with me that select is not a DML, and why?

My thinking is, as Select is not modifying data in table, and DML denotes set of statements, which can modify data in table.

Thanks.

Pravin

 

[JeanNiBee]

DML -> Data Manipulation Language

not Modifying...



-=-=-=-=-=-=-=-=-
For ease of reading, any posted CODE should be wrapped by [ignore][COLOR][/COLOR] and

[/ignore] tags.

Ex:

SELECT 1 from sysobjects

 

[sybaseguru]

Pravin,

I think our friend JeanNiBee has pointed it out nicely. Traditionally any sql type statement such as select/insert/update/delete is considered a Data manupulation Language. In contrast anything which affects the underlying structure is DDL or Data Definition Language (create/alter/drop table etc). Then we end of with remaining stuff which are compiled objects (check constraints, defaults, rules, stored procedures, triggers and views).