Search For Knowledge

Google

Monday, July 14, 2008

Two Good SQL Tricks

Actually these two things are not Tricks for SQL Masters, but for dummies like me hope this will help a lot.
1. To find the specific table name, with a part of table name we can use this Query
sp_tables '%USR%' This will give u the result of table name with "USR" word.
2. Once you got a table name to get all the details. Just use the table name in ur editor then select the table name fully and press "ALT+F1". This will give you the details about the table, its contents and options inside.

Good Day