Shulou(Shulou.com)05/31 Report--

Editor to share with you how to obtain the table structure of SQL, I believe that most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to understand it!

Set arg=wscript.arguments

If arg.count = 0 Then

Show_help ()

Wsh.quit

End If

Server = arg (0)

User = arg (1)

Pass = arg (2)

Database_name = arg (3)

Table_name = arg (4)

Set Conn = CreateObject ("ADODB.Connection")

Conn.Open "Driver= {SQL Server}; Server=" & Server & "; UID=" & User & "; PWD=" & Pass & "; Database=" & database_name

Set rs = conn.execute ("select count (*) as n from" & database_name & ".dbo.sysobjects where id = object_id (N [dbo]. [" & table_name & "]))

If rs ("n")

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.