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
Search For Knowledge
Monday, July 14, 2008
Subscribe to:
Posts (Atom)