Shulou(Shulou.com)06/03 Report--

This article mainly introduces how to achieve SQL to get the show_table.vbs of the table structure, the article introduces in great detail, has a certain reference value, interested friends must read it!

The code is as follows:

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.