To get all information about current database. (TableName, FieldName, Type, Length, NULLable, Refer, and more ...) It's usefull when you want to compare 2 versions (old & new) of a database. Because while you develop an application you can change database's structure (add more fields, change type of fields, ...), and you want to ensure that the databse'structure that you delivery is the same with custummer's. => You must only run this script with 2 version of database, put result to 2 text files and compare 2 files by any tool. Have fun, :) & vote 4 me :D
File List:
@PSC_ReadMe_930_5.txt
1Kb
SQLS_GetDBInfo.sql
3Kb
Similar code
Avoiding Cursors
(Popularity: ) : Some times, in our query, we may use temporary tables and cursor's to get the required result. This implementation in ...
Code Library
) : Some times, in our query, we may use temporary tables and cursor's to get the required result. This implementation in ...