you can runEXPLAIN Users; to get all the fields & types, etc.
How would you do this same thing in SQL 2000?There are several ways to get this information. sp_help would be a good place to start: sp_help Users
Terri
Showing posts with label runexplain. Show all posts
Showing posts with label runexplain. Show all posts
Friday, March 9, 2012
mysql EXPLAIN = what in MS SQL 2000
If you have a table namedUsers then using mysql
you can runEXPLAIN Users; to get all the fields & types, etc.
How would you do this same thing in SQL 2000?There are several ways to get this information. sp_help would be a good place to start: sp_help Users
you can runEXPLAIN Users; to get all the fields & types, etc.
How would you do this same thing in SQL 2000?There are several ways to get this information. sp_help would be a good place to start: sp_help Users
Subscribe to:
Posts (Atom)