SQLSERVERæ¥è¯¢æææ°æ®åºä¸å建ç表åå表ä¸å段åçè¯å¥ï¼ä»£ç å¦ä¸ï¼
##è·åæææ°æ®åºå:
SELECT Name FROM Master..SysDatabases ORDER BY Name
##è·åå建çææ表
SELECT Name FROM DatabaseName..SysObjects Where XType='U' ORDER BY Name
#XType='U':表示ææç¨æ·è¡¨;
#XType='S':表示ææç³»ç»è¡¨;
#è·å表ä¸ææå段å
SELECT Name FROM SysColumns WHERE id=Object_Id('TableName')